Excel 2013: Applying Formulas and Functions

 

Name that Tune

graphic1

 

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

Watch the video

 

Project

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

 

Downloads

Counting Chickens 2013.xlsx

Using Named Ranges COMPLETED.xlsx

Employee Data.xlsx

 

2. Practice

Complete the Practice Activity on page 108.

 

3. Assessment

Do the Test Yourself questions on page 108.

 

graphci3
graphic2