Excel+Chapter+3

=**// Microsoft Excel 2007 //**= =**// Chapter 3: What-If Analysis, Charting, and Working with Large Worksheets //**=

__**// Objectives //**__

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


 * 1) == Read pages EX162 - EX167, //What-IF Analysis, Charting, and Working with Large Worksheets//==

Complete Project Step-by-Step, pages EX167 - EX87, //Start Excel//
__**// Assignments //** __
 * 1) == Complete Project Step-by-Step, page EX168 - EX87: //Enter the Worksheet Titles, change Workbook Properties, Apply a Theme, and Save the Workbook//==
 * 2) == Read page EX168, //Rotating Text and Using the Fill Handle to Create a Series//==
 * 3) == Complete Project Step-by-Step, pages EX168 - EX171: //Rotate Text and Use the Fill handle to Create a Series of Month Names//==
 * 4) == Read pages EX171 - EX172: //Using the Auto Fill Options Menu//==
 * 5) ==Complete Project Step-by-Step, pages EX173: //Increase Column Widths and Enter Row Titles//==
 * 6) == Read page EX174//, Copying a Range of Cells to a Nonadjacent Destination Area//==
 * 7) ==Complete Project Step-by-Step, pages EX175 - EX176: //Copy a Range of Cells to a Nonadjacent Destination Area//==
 * 8) == Read pages EX176 - EX177, //Using the Paste Options Menu//==
 * 9) == Complete Project Step-by-Step, pages EX177 - EX179: //Insert a Row//==
 * 10) ==Read page EX179, //Inserting Columns//==
 * 11) ==Read page EX179, //Inserting Single Cells or a Range of Cells//==
 * 12) ==Read page EX179, //Deleting Individual Cells or a Range of Cells//==
 * 13) ==Read page EX179, //Entering Numbers with Format Symbols//==
 * 14) == Complete Project Step-by-Step, page EX181: //Enter Numbers with Format Symbols//==
 * 15) ==Read page EX181, //Freezing Worksheet Titles//==
 * 16) ==Complete Project Step-by-Step, page EX182, //Freeze Column and Row Titles//==
 * 17) == Complete Project Step-by-Step, page EX183: //Enter the Projected Monthly Sales//==
 * 18) == Complete Project Step-by-Step, page EX98: //Determine the Total Percent Gain/Loss//==
 * 19) ==Read page EX183: //Displaying a System Date//==
 * 20) ==Complete Project Step-by-Step, pages EX184 - EX185, //Enter and Format the System Date//==
 * 21) ==Read pages EX186 - EX187: //Absolute Versus Relative Addressing//==
 * 22) ==Complete Project Step-by-Step, pages EX187 - EX188: //Enter a Formula Containing Absolute Cell References//==
 * 23) == Read page EX189//, Making Decisions--The IF Function//==
 * 24) == Complete Project Step-by-Step, page EX190: //Enter an IF Function//==
 * 25) == Complete Project Step-by-Step, page EX191: //Enter the Remaining January Formulas//==
 * 26) == Complete Project Step-by-Step, pages EX192 - EX193: //Copy Formulas with Absolute Cell References Using the Fill Handle//==
 * 27) == Complete Project Step-by-Step, page EX194: //Determine Row totals in Nonadjacent Cells//==
 * 28) ==Complete Project Step-by-Step, pages EX194 - EX195: //Unfreeze the Worksheet Titles and Save the Workbook//==
 * 29) ==Read page EX195, Nested Forms of the IF Function==
 * 30) ==Read pages EX195 - EX196, Formatting the Worksheet==
 * 31) ==Complete Project Step-by-Step, pages EX196 - EX198: //Assign Formats to Nonadjacent Ranges//==
 * 32) ==Complete Project Step-by-Step, pages EX199 - EX200: //Format the Worksheet Titles//==
 * 33) ==Complete Project Step-by-Step, page EX200 - EX198: //Assign Cell Styles to Nonadjacent Rows and Colors to a Cell//==
 * 34) ==Read page EX201, //Copying a Cell's Format Using the Format Painter Button//==
 * 35) ==Complete Project Step-by-Step, pages EX201 - EX202: //Copy a Cell's Format Using the Format Painter Button//==
 * 36) ==Complete Project Step-by-Step, page EX203: //Format the What-If Assumptions Table and Save the Workbook//==
 * 37) ==Read page EX204, //Adding a 3-D Pie Chart to the Workbook//==
 * 38) ==Complete Project Step-by-Step, pages EX205 - EX206: //Draw a 3-D Pie Chart on a Separate Chart Sheet//==
 * 39) ==Complete Project Step-by-Step, pages EX265 - EX209: //Insert a Chart Title and Data Labels//==
 * 40) ==Complete Project Step-by-Step, pages EX209 - EX210: //Rotate the 3-D Pie Chart//==
 * 41) ==Complete Project Step-by-Step, pages EX211 - EX213: //Apply a 3-D Format to the Pie Chart//==
 * 42) ==Complete Project Step-by-Step, pages EX213 - EX214: //Explode the 3-D Pie Chart and Change the Color of a Slice//==
 * 43) ==Complete Project Step-by-Step, page EX215: //Change the Colors of the Remaining Slices//==
 * 44) ==//Read page EX216, Renaming and Reordering the Sheets and Coloring Their Tabs//==
 * 45) ==Complete Project Step-by-Step, pages EX216 - EX217: //Rename and Reorder the Sheets and Color Their Tabs//==
 * 46) ==Read page EX218: //Checking Spelling, Savings, Previewing, and Printing the Workbook//==
 * 47) ==Complete Project Step-by-Step, page EX218: //Check Spelling in Multiple Sheets//==
 * 48) ==Complete Project Step-by-Step, pages EX218 - EX219: //Preview and Print the Workbook//==
 * 49) ==Read page EX220//, Changing the View of the Worksheet//==
 * 50) ==Complete Project Step-by-Step, pages EX220 - EX221: //Shrink and Magnify the View of a Worksheet or Chart//==
 * 51) ==Complete Project Step-by-Step, pages EX222 - EX223: //Split a Window into Panes//==
 * 52) ==Complete Project Step-by-Step, page EX223: //Remove the Panes from the Window//==
 * 53) ==Read pages EX223 - EX224, //What-If Analysis//==
 * 54) ==Complete Project Step-by-Step, page EX224: //Analyze Data in a Worksheet by Changing Values//==
 * 55) ==Complete Project Step-by-Step, pages EX225 - EX227: //Goal Seek//==
 * 56) ==Read page EX227, //Goal Seeking//==
 * 1) == Complete Review Questions ( Excel 2007 Chapter 3 Review Questions.doc)==
 * 2) ==Complete //Apply Your Knowledge//, pages EX229 - EX230: ** Absolute Cell References Parts 1, 2 and 3 (Place the answers for parts 1 and 2 in Word) **==
 * 3) ** Complete //Extend Your Knowledge//, pages EX230 - EX231: Create Series Complete **
 * 4) == Complete //In the Lab, Lab 2//, pages EX237 - EX241: ** Britney's Music Emporium, Britney's Music Emporium Weekly Payroll Report Complete, and Britney's Music Emporium Weekly Payroll Report Complete Part 3 (File will be saved three times with different changes in each file) **==

__**// Enrichment Exercises //**__

 * 1) == Complete Cases and Places Project 4, pages EX246 - EX247: **College Expense and Resource Projections**==