Excel Chapter 9

Demonstrable Skill	Learning Activities & Informal Assessments	Formal Assessments (excluding Exams)
Create 3-D formulas which reference data on other worksheets.	Excel: Formulas & Functions II Participation Project Excel: Formulas & Functions III Participation Project MyLab Lesson A	Old Homework #2 MyLab Lesson A
Create validation rules to control data values.	MyLab Lesson B	MyLab Lesson B
Simultaneously modify multiple worksheets.	MyLab Lesson A	MyLab Lesson A
Protect spreadsheets from changes.	MyLab Lesson B	MyLab Lesson B

3-D references

A 3-D reference is a pointer to a cell in the other worksheet [1]. In a 3-D reference, the worksheet name is separated from the cell reference by an exclamation mark.

 =SUM(‘First Worksheet:Last Worksheet’!RangeOfCells)

For example, in=SUM(‘Qtr1:Qtr4’!E3), Qtr1:Qtr4are four worksheets named Qtr1, Qtr2, Qtr3, and Qtr4. E3 refers to a cell on each of those worksheets.

3-D references

Don't type 3-D references - you can, but it's easy to make a mistake!  Start the formula then click on the worksheet and cell you want to reference! It's much easier [2].