Excel Chapter 2

Formulas, Functions, and Formatting

The new topics in this chapter include using formulas and functions to create worksheet.  A function is a prewritten formula that is built into Excel.  Other new topics include buttons, verifying formulas, applying a theme to a worksheet, adding borders, formatting numbers and text, using conditional formatting, changing the widths of columns and heights of rows, spell checking, using alternative types of worksheet displays and printouts, and adding page headers and footers to a worksheet.  One alternative worksheet display and printout shows the formulas int eh worksheet instead of the values.  When you display the formulas in the worksheet, you see exactly what text, data, formulas, and functions you have entered into it.

CONCEPT MAP OF UNIT

Microsoft Excel – Formulas, Functions, and Formatting

 

Key Learning (s):   

Learning Excel will provide you with the ability to manipulate numerical data in resolving issues related to finances or other numbers-based information.

 

Unit Essential Question(s):           

How do you prepare and format an Excel Worksheet?

 


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 real-time data from a Web site?

·         How do you e-mail 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

 


Subpages (1): Vocabulary
Č
ĉ
Allison Lawhead,
Oct 6, 2011, 8:09 AM
Comments