Comma Training Page 84

Formulas

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

Project

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

Downloads

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

Menu Maps

This lesson demonstrates options on the Formulas Ribbon.

1. Formulas->Defined Names->Define Name, page 89

2. Formulas->Defined Names->Name Manager, page 93

3. Formulas->Defined Names ->Use in Formula, page 97

4. Formulas->Function Library->Math and Trig -> SUMIF, page 98

5. Formulas->Function Library->Math and Trig -> SUMIFS, page 99

6. Formulas->Function Library->More Functions ->Statistical ->COUNTIF, page 101

7. Formulas ->Function Library->More Functions -> Statistical ->COUNTIFS, page 102

8. Formulas ->Function Library->More Functions -> Statistical ->AVERAGEIF, page 103

9. Formulas ->Function Library->More Functions -> Statistical ->AVERAGEIFS, page 104