Entering
Titles, Numbers, and Formulas

Using the
AVERAGE, MAX, and MIN functions

Formatting
the Worksheet

Displaying
and Printing the Formulas Version of the Worksheet

Lesson Essential Questions
·
How do you enter formulas using
the keyboard and Point mode?
·
How do you verify a formula
using Range Finder?

Lesson
Essential Questions
·
How can you apply the AVERAGE, MAX, and MIN functions?

Lesson
Essential Questions
·
How is a theme applied to a workbook?
·
How can you add conditional formatting to cells?
·
How do you change the column width and row height?
·
How do you check the spelling of a worksheet?
·
How are sheets in a workbook renamed?

Lesson
Essential Questions
·
How do you set margins, headers, and footers in Page
Layout View?
·
How do you preview and print versions of a workbook?
·
How do you use a Web query to get realtime data from a
Web site?
·
How do you email the active workbook from within Excel?

VOCABULARY
Formula
Arguments
Order of Operations

VOCABULARY
MAX function
MIN function
Range finder

VOCABULARY
Fixed dollar sign
Floating dollar sign
Comma style format
Accounting number format
Condition
Pixel
Best fit

VOCABULARY
Spell
checker
Page
layout view
Normal
view
Header
Footer
Values
version
Formulas
version
Debugging
