Class 11 Notes (notes are in progress and are subject to change)

Introduction:

<Log On>

Discourse
Minimize Discourse

Copy 11charts from Class folder to your shared folder in Groups

Class 11 Outline

• Short Excel Quiz
• Review Running Balance, Relative and Absolute Cell Refs
• Spreadsheets in Class
• Using Templates

Displaying Formulas in a Spreadsheet:

Spreadsheets in Class:

• Commission Review - absolute and relative cell references
• Ice Cream
• Hotel Occupancy
• September Highs - show conditional formatting
• Chart Practice

Using the Templates in MS Excel 2007 - click here for practice directions

Conditional Formatting Review: Select cells and go to Conditional Formatting>Top Bottom Rules>More Rules

Format only cells that contain . . . . .

Set conditions:

Chart Practice in Class

Homework:

1. Continents, Parts 1 and 2
(found between pp. 293-297 - experiment with different color schemes for chart, choose one as your favorite and save)

2. Temperature, Parts 1 and 2
(found between pp. 301 - 313)

3. Employee Discounts (p. 344)

<log off>