Lesson+2

=**// Microsoft Excel 2007 //**= =**// Chapter 2: Formulas, Functions, Formatting, and Web Queries //**=

__**// Objectives //**__

 * ==Enter formulas using the keyboard and Point mode== || ==Set margins, headers and footers in Page Layout View== ||
 * ==Apply the AVERAGE, MAX, and MIN functions== || ==Preview and print versions of a worksheet== ||
 * ==Verify a formula using Range Finder== || ==Use a web query to get real-time data form a Web site== ||
 * ==Apply a theme to a workbook== || ==Rename sheets in a workbook== ||
 * == Add conditional formatting to cells== || ==E-mail the active workbook from within Excel== ||
 * ==Change column width and row height== || ==Check the spelling of a worksheet== ||

__**// Assignments //** __
 * 1) == Read pages EX82 - EX86, //Formulas, Functions, Formatting, and Web Queries//==
 * 2) == Read pages EX86 - EX87, //Start Excel//==
 * 3) == Complete Project Step-by-Step, pages EX86 - EX87: //Start Excel//==
 * 4) == Read page EX87, //Entering the Titles and Numbers into the worksheet//==
 * 5) == Complete Project Step-by-Step, page EX87: //Enter the Worksheet Title and Subtitle//==
 * 6) == Complete Project Step-by-Step, pages EX87 - EX88: //Enter the Column Titles//==
 * 7) ==Complete Project Step-by-Step, page EX88: //Enter the Portfolio Summary Data//==
 * 8) == Complete Project Step-by-Step, pages EX88 - EX89: //Enter the Row Titles//==
 * 9) ==Complete Project Step-by-Step, page EX90: //Change Workbook Properties and Save the Workbook//==
 * 10) == Read page EX90, //Entering Formulas//==
 * 11) == Complete Project Step-by-Step, page EX91: //Enter a Formula Using the Keyboard//==
 * 12) ==Read page EX92, //Arithmetic Operations//==
 * 13) ==Read page EX92, //Order of Operations//==
 * 14) == Complete Project Step-by-Step, pages EX93 - EX94: //Enter formulas Using Point Mode//==
 * 15) == Complete Project Step-by-Step, pages EX95 - EX96, //Copy Formulas Using the Fill Handle//==
 * 16) == Read pages EX96 - EX97, //Smart Tags and Option Buttons//==
 * 17) == Complete Project Step-by-Step, page EX97: //Determine totals Using the Sum Button//==
 * 18) == Complete Project Step-by-Step, page EX98: //Determine the Total Percent Gain/Loss//==
 * 19) ==Read pages EX98 - EX99: //Using the AVERAGE, MAX, AND MIN Functions//==
 * 20) ==Complete Project Step-by-Step, pages EX99 - EX100, //Determine the Average of a Range of Numbers Using the Keyboard and Mouse//==
 * 21) == Complete Project Step-by-Step, pages EX101 - EX102: //Determine the Highest Number in a Range of Numbers Using the Insert//==
 * 22) == Complete Project Step-by-Step, pages EX102 - EX104: //Determine the Lowest Number in a Range of Numbers Using the Sum Menu//==
 * 23) == Complete Project Step-by-Step, pages EX104 - EX105: //Copy a Range of Cells Across Columns to an Adjacent Range Using the Fill Handle//==
 * 24) == Complete Project Step-by-Step, page EX106: //Save a Workbook using the Same File Name: Silver Dollars Stock Club portfolio Summary//==
 * 25) == Read page EX106: //Verifying Formulas Using Range Finder//==
 * 26) == Complete Project Step-by-Step, page EX106: //Verify a Formula Using Range Finder//==
 * 27) == Read pages EX107 - EX108: //Formatting the Worksheet//==
 * 28) == Complete Project Step-by-Step, page EX109: //Change the Workbook Theme//==
 * 29) == Complete Project Step-by-Step, pages EX110: //Format the Worksheet Titles//==
 * 30) == Complete Project Step-by-Step, pages EX110 - EX112: //Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle//==
 * 31) == Complete Project Step-by-Step, page EX112: //Apply a Cell Style to the Column Headings and Format the Total Rows//==
 * 32) == Complete Project Step-by-Step, pages EX113 - EX114: //Center Data in Cells and format Dates//==
 * 33) == Read page EX114: //Formatting Numbers Using the Ribbon//==
 * 34) == Complete Project Step-by-Step, pages EX115 - EX116: //Apply an Accounting Style Format and Comma Style Format Using the Ribbon//==
 * 35) == Complete Project Step-by-Step, pages EX116 - EX117, //Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box//==
 * 36) == Complete Project Step-by-Step, page EX118: //Apply a Percent Style Format and Use the Increase Decimal Button//==
 * 37) == Read page EX118, //Conditional Formatting//==
 * 38) == Complete Project Step-by-Step, pages EX119 - EX121: //Apply Conditional Formatting//==
 * 39) ==Read page EX121, //Conditional Formatting Operators//==
 * 40) ==Read page EX122, //Changing the Widths of Columns and Heights of Rows//==
 * 41) == Complete Project Step-by-Step, page EX122 - EX124: //Change the Widths of Columns//==
 * 42) ==Complete Project Step-by-Step, pages EX125 - EX126: //Change the Heights of Rows//==
 * 43) ==Read page EX127//, Checking Spelling//==
 * 44) == Complete Project Step-by-Step, pages EX127 - EX128: //Check Spelling on the Worksheet//==
 * 45) == Read page EX129, //Additional Spell Checker Considerations//==
 * 46) ==Read page EX129, //Preparing to Print the Worksheet//==
 * 47) ==Complete Project Step-by-Step, pages EX130 - EX132: //Change the Worksheet's Margins, Header, and Orientation in Page Layout View//==
 * 48) ==Read page EX132, //Previewing and Printing the Worksheet//==
 * 49) ==Complete Project Step-by-Step, pages EX132 - EX134: //Preview and Print a Worksheet//==
 * 50) ==Complete Project Step-by-Step, pages EX134 - EX135: //Print a Section of the Worksheet//==
 * 51) ==Read page EX135, //Displaying and Printing the Formulas Version of the Worksheet//==
 * 52) ==Complete Project Step-by-Step, page EX136: //Display the Formulas in the Worksheet and Fit the Printout on One Page//==
 * 53) ==Complete Project Step-by-Step, page EX137: //Change the Print Scaling Option Back to 100%//==
 * 54) ==Read page EX137: //Importing External Data from a Web Source Using a Web Query//==
 * 55) ==Complete Project Step-by-Step, pages EX138 - EX140: //Import Data from a Web Source Using a Web Query//==
 * 56) ==Read page EX140: //Changing the Worksheet Names//==
 * 57) ==Complete Project Step-by-Step, page EX141: //Change the Worksheet Names//==
 * 58) ==Read page EX142: //E-Mailing a Workbook from Within Excel//==
 * 59) ==Complete Project Step-by-Step, pages EX142 - EX143: //E-Mail a Workbook from Within Excel//==
 * 1) == Complete Review Questions ( Excel 2007 Chapter 2 Review Questions.doc)==
 * 2) ==Complete //Apply Your Knowledge//, pages EX145 - EX146: ** Car-B-Clean Profit Analysis Part 1 and Part 2 (File will be saved two times with different changes in each file) **==
 * 3) ** Complete //Extend Your Knowledge//, pages EX147: Biology 201 Midterm Scores **
 * 4) == Complete //In the Lab, Lab 2//, pages EX151 - EX154: ** Jackson's Bright Ideas Part 1 and Part 2 (File will be saved two times with different changes in each file) **==

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

 * 1) == Complete Cases and Places Project 1 page EX156: ** Choose to Lose **==
 * 2) == Complete Cases and Places Project 3, page EX158: **Create a Fund-Raising Analysis Worksheet **==