1. Readings
Read Lesson 3 in the Intermediate Excel guide, page 83-108.



A spreadsheet that uses Defined Names in formulas to conditionally summarize data.



Counting Chickens 2010 Complete.xlsx

Using Named Ranges.xlsx

Employee Data.xlsx


2. Practice

Complete the Practice Activity on page 108.


3. Assessment

Do the Test Yourself questions on page 108.


Lesson 3: Name that Tune