Chapter+1

=**// Microsoft Excel 2007 //**= =**// Chapter 1: Creating a Worksheet and an Embedded Chart //**=

__**// Objectives //**__

 * ==Start and quit Excel== || ==Change document properties== ||
 * ==Describe the Excel worksheet== || ==Save a workbook a second time using the same file name== ||
 * ==Enter text and numbers== || ==Print a worksheet== ||
 * ==Use the Sum button to sum a range of cells== || ==Open a workbook== ||
 * == Save a workbook== || ==Use the Auto Calculate area to determine statistics== ||
 * ==Copy the contents of a cell to a range of cells using the fill handle== || ==Correct errors on a worksheet== ||
 * ==Format cells in a worksheet== || ==Use Excel Help to answer questions== ||
 * ==Create a 3-C Clustered Column chart== ||  ||


 * 1) == Read page EX2, //What is Microsoft Office Excel 2007?//==
 * 2) == Read pages EX2 - EX6, //Project – Worksheet with an Embedded Chart//==
 * 3) == Complete Project Step-by-Step, pages EX6 - EX7: //Start Excel//==
 * 4) == Read pages EX7 - EX8, //The Excel Workbook//==
 * 5) == Read pages EX9 - EX16, //Worksheet Window//==
 * 6) == Complete Project Step-by-Step, page EX17: //Enter the Worksheet Titles//==
 * 7) ==Read pages EX18 - EX19, //Entering Text in a Cell, Correcting a Mistake while Typing, and AutoCorrect//==
 * 8) == Complete Project Step-by-Step, pages EX19 - EX21: //Enter Column Titles//==
 * 9) ==Complete Project Step-by-Step, pages EX21 - EX22: //Enter Row Titles//==
 * 10) == Read pages EX22 - EX23, //Entering Numbers//==
 * 11) == Complete Project Step-by-Step, pages EX23 - EX24: //Enter Numbers//==
 * 12) == Read page EX24, //Calculating a Sum//==
 * 13) ==Complete Project Step-by-Step, pages EX25 - EX26: //Sum a Column of Numbers//==
 * 14) == Read pages EX26 - EX27, //Using the Fill Handle to Copy a Cell to Adjacent Cells//==
 * 15) == Complete Project Step-by-Step, pages EX27 - EX28: //Copy a Cell to Adjacent Cells in a Row//==
 * 16) == Complete Project Step-by-Step, pages EX28 - EX29: //Determine Multiple Totals at the Same Time//==
 * 17) == Read pages EX29 - EX30, //Saving the Project//==
 * 18) == Complete Project Step-by-Step, pages EX30 - EX32: //**Save a Workbook: Walk and Rock Music 1st Quarter Sales**// ==
 * 19) == Read pages EX33 - EX34, //Formatting the Worksheet//==
 * 20) == Complete Project Step-by-Step, pages EX35 - EX36: //Change a Cell Style//==
 * 21) == Complete Project Step-by-Step, pages EX36 - EX37: //Change the Font Type//==
 * 22) ==Complete Project Step-by-Step, page EX38: //Bold a Cell//==
 * 23) ==Complete Project Step-by-Step, pages EX38 - EX39, //Increase the Font Size of a Cell Entry//==
 * 24) == Complete Project Step-by-Step, pages EX39 - EX40: //Change the Font Color of a Cell Entry//==
 * 25) == Complete Project Step-by-Step, pages EX40 - EX41: //Center Cell Entries Across Columns by Merging Cells//==
 * 26) == Complete Project Step-by-Step, pages EX42 - EX43: //Format Column Titles and the Total Row//==
 * 27) == Complete Project Step-by-Step, pages EX44 - EX45: //Format Numbers in the Worksheet//==
 * 28) == Complete Project Step-by-Step, page EX46: //Adjust the Column Width//==
 * 29) == Read page EX47: //Using the Name Box to Select a Cell//==
 * 30) == Complete Project Step-by-Step, page EX47: //Use the Name Box to Select a Cell//==
 * 31) == Read page EX48: //Other Ways to Select Cells//==
 * 32) == Read pages EX49 - EX50: //Adding a 3-D Clustered Column chart to the Worksheet//==
 * 33) == Complete Project Step-by-Step, pages EX50 - EX54: //Add a 3-D Clustered Column Chart to the Worksheet//==
 * 34) == Read page EX54: //Changing Document Properties and Saving Again//==
 * 35) == Complete Project Step-by-Step, pages EX55 - EX56: //Change Document Properties//==
 * 36) == Complete Project Step-by-Step, pages EX56 - EX57: //Save an Existing Workbook with the Same File Name: Walk and Rock Music 1st Quarter Sales//==
 * 37) == Read page EX57: //Printing a Worksheet//==
 * 38) == Complete Project Step-by-Step, page EX58: //Print a Worksheet//==
 * 39) == Read page EX59, //Quitting Excel//==
 * 40) == Complete Project Step-by-Step, page EX59: //Quit Excel with One Workbook Open//==
 * 41) == Read page EX60, //Starting Excel and Opening a Workbook//==
 * 42) == Complete Project Step-by-Step, pages EX60 - EX61: //Open a Workbook from Excel//==
 * 43) ==Read page EX62, AutoCalculate==
 * 44) == Complete Project Step-by-Step, pages EX62 - EX63: //Use the AutoCalculate Area to Determine a Maximum//==
 * 45) == Read page EX63 - EX67, //Correcting Errors//==
 * 46) ==Read page EX67, //Excel Help//==
 * 47) == Complete Project Step-by-Step, pages EX67 - EX68: //Search for Excel Help//==
 * 48) == Read page EX69, //Quit Excel//==

__**// Assignments //** __
 * 1) == Complete Review Questions ( Excel 2007 Chapter 1 Review Questions.doc)==
 * 2) ==Complete //Apply Your Knowledge//, pages EX70 - EX71: ** Spoke-Up Bicycle Shop 3rd Quarter Sales **==
 * 3) ** Complete //Extend Your Knowledge//, pages EX72 - EX73: Pack-n-Away Shipping Charts **
 * 4) == Complete //In the Lab, Lab 2//, pages EX75 - EX77: ** Annual Sales Analysis Worksheet (__save changes__) **==
 * 5) == Complete //In the Lab, Lab 3//, pages EX77 - EX79: ** College Cost and Financial Support Part 1, Part 2, and Part 3 (File will be saved three times with different changes in each file) **==

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

 * 1) == Complete Cases and Places Project 1 page EX79: ** Hit-the-Road Mobile Services **==
 * 2) == Complete Cases and Places Project 3, page EX80: ** In-the Villa DVD Rental **==