Mrs. King-Licht's Classes - Home



Chapter 3: Formulas, Functions, and FormattingObjectivesEnter formulas using the keyboardEnter formulas using the Point ModeApply AVERAGE, MAX, and MIN functionsVerify a formula using Range FinderApply a theme to a workbookApply a date format to a cell or rangeAdd conditional formatting to cellsChange column width and row heightCheck the spelling in a worksheetSet margins, headers, and footer in Page Layout viewPreview and print versions of a worksheetComplete all Step by Step Activities Below: Page EX 66 through Ex 121 Complete Step by Step Page Ex: 71 – 74 “Entering the Titles and Numbers into the Worksheet”Complete Step by Step Page Ex: 75 – 81 “Entering Formulas”Complete Step by Step Page Ex: 82 – 83 “Option Buttons”Complete Step by Step Page Ex: 84 – 90 “ Using the AVERAGE, MAX, AND MIN Functions”Complete Step by Step Page Ex: 91 “ Verifying Formulas Using Range Finder”Complete Step by Step Page Ex: 92 -111 “ Formatting the Worksheet”Complete Step by Step Page Ex: 112 – 113 “Checking Spelling”Complete Step by Step Page Ex: 114 – 116 “Preparing to Print the Worksheet”Complete Step by Step Page Ex: 117 – 118 “Printing the Worksheet”Complete Step by Step Page Ex: 119 – 121 “Displaying and Printing the Formulas Version of the Worksheet”Assignments:Apply Your Knowledge Profit Analysis Worksheet Ex:122-124Template: Apply 2-1 Village of Scott Police DepartmentRe-Save Apply 2-1 YourLastNameExtend Your Knowledge Applying Conditional Formatting to Cells Pg Ex: 124 - 125Template: Extend 2-1 State Wildlife Department Employee RatingsRe-Save Extend 2-1 YourLastNameMake It Right Correcting Formatting Functions, and Formulas in a WorksheetPg Ex:125 - 126Template: Make It Right 2-1 Dion Designwear Profit AnaylisRe-Save Make It 2-1 YourLastNameIn The Lab 1 Accounts Receivable Balance Worksheet Pg Ex: 126 - 129Template: None you create from textbookRe-Save Excel Ch 2 Lab 1 YourLastNameIn The Lab 2 Sales Summary Worksheet Pg Ex: 129 - 131Template: None you create from textbookRe-Save Excel Ch 2 Lab 2 YourLastNameIn The Lab 3 Stock Club Investment Analysis Pg Ex: 132 - 133Template: None you create from textbookRe-Save Excel Ch 2 Lab 3 YourLastName ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download