Contents

Overview – Range Names and SERIES. 7

Relative and Absolute Cell References. 7

Range Names. 7

SERIES Formula. 8

SERIES Formula and Range Names. 9

Review Questions- Overview.. 12

Overview of OFFSET and COUNT Functions. 13

OFFSET Function. 13

COUNT Functions. 14

Create an Automatically Expanding Chart 15

Review Questions -OFFSET and COUNT Functions. 19

Review Exercise -Self Expand. 20

Review Exercise -Self Expand 2 Series. 21

Controlling Data in a Self-Expanding Chart 22

Display the Last X Data Points in the Worksheet 22

Review Exercise – Display 4 Data Points. 25

Selecting a Beginning and Ending Point for a Series. 27

Review Exercise -Beginning and Ending Point 30

Scroll Bars and Spinners. 32

Create a Spinner. 32

Scroll Bar. 35

Linking Title Text to a Cell 36

Review Questions -Scroll Bars and Spinners. 38

Feedback Answers to Review Questions. 39

Glossary. 42

Creating Dynamic & Interactive Charts Exam.. 45