M.+Excel+Ch.+3

=Chapter 3 ~ What-If Analysis, Charting & Working with Large Worksheets=

Objectives:

 * Rotate text in a cell
 * Create a series of month names
 * Copy, paste, insert and delete cells
 * Format numbers using format symbols
 * Freeze and unfreeze rows and columns
 * Show and format the system date
 * Use absolute and mixed cell references in a formula
 * Use the IF function to perform a logical test
 * Create Sparkline charts
 * Use the Format painter button to format cells
 * Create a 3-D Pie chart on a separate chart sheet
 * Rearrange worksheet tabs
 * Change the worksheet view
 * Answer what-if questions
 * Goal seek to answer what-if questions

Assignments:

 * 1) Modern Music Shops - we did together as a class
 * 2) In the Lab 1 - parts 1 & 2