Objective enter and edit data in worksheet create and use formulas to perform calculations  I.  Bellwork A.  Draw the following buttons from the Excel toolbars Redo Undo Chart Wizard Percent Style Font Color II.  Classwork A.  Finish & Print Exercise 14 Page 299 (Show Gridlines/Row&Column Headings) Not Formulas B.  Print– Micro Type Pro Red Section […]

 Objectives: Use the SUM, AVERAGE, MAX, MIN, and ROUND functions. Sort the data in a spreadsheet. Insert and delete rows and columns I.  Bellwork pg 278 A.  What commands create a new worksheet? B.  What is a linked cell? II.  Notebook Work – Bar Graph A.  Write Questions and Answers III.  Classwork A.  Car Sales Pgs […]

Objective: Create an amortization table using the PMT function. Organize data using multiple sheets in a workbook. I.   Bellwork  (Pg 275) A.  What is an amortization table? B.  What is the PMT function and what form does it take? II.  Classwork A.  Loan Pgs 275-277 (Follow Directions for Part 8 & Print it out.) B.  Car Sales […]

Objectives:  Use text in the IF function.  Use the SUM, AVERAGE, MAX, MIN, and ROUND functions I.  Bellwork  A.  Explain the difference between the merge and centering formatting option and centering B.  Explain the difference between clicking the currency style button on the toolbar and selecting Format-Cells-Number-Currency- 2 decimal places. II.  Writing Activity – Persistence […]

Objective: Use the IF function. Change the print orientation and margins of a worksheet.  I.  Bellwork A.  Draw the following buttons from the Excel toolbars Increase Decimal  Fill Color  Right Align Print Preview New II.  Classwork A.  Exercise 10 Chapter 10 -Print B.  Exercise 11 Chapter 10 – Print C.  Micro Type Pro E-F Due […]

Objectives:   Use the SUM, AVERAGE, MAX, MIN, and ROUND functions I.  Bellwork – Questions & Answers In Excel what is the symbol for multiplication? In excel what is the symbol for division? What must all formulas start with? Write the formula to SUM the cells A5 to G5. II.  Classwork A.  Exercise 9 Chapter 10 […]

Objective: Use the IF function. Change the print orientation and margins of a worksheet. Print part of a worksheet. Use text in the IF function.  I. Bellwork Work A.  pg 285 #17 a, b, c II.  Classwork Hotel Occupancy Part 2 Pg 269  Payroll Part 1 of 3 Pgs 271-273 Hotel Occupancy Part 3  Pg 274 […]

Objectives:  Use the SUM, AVERAGE, MAX, MIN, and ROUND functions. Sort the data in a spreadsheet. Insert and delete rows and columns. I.  Bellwork A.  Page 285 #15a & b Questions and Answers (See pg 268) II.  Classwork A.  Formula Review Sheet (Test Friday) B.  Page 267 Hotel Occupancy Part I C.  Page 269 Hotel […]

 Objective: enter and edit data in worksheet insert functions into formulas I.  Bellwork A.  Pg 285 Questions and Answers #13 & #14 II.  Classwork A.  Exercise 4 Chapter 10 – Print B.  Pages 265-266 Mileage Summary – Print III.  Micro Type Pro E-F due next week

Objective  Use functions enter and edit data in worksheet use formulas to perform calculations I.  Bellwork A.  Draw the following buttons from the Excel toolbars Merge and Center Spelling  Sort Ascending Format Painter AutoSum   II.  Notebook Work  A.  Click Here –  Pie Chart 1 Questions B.  Write Questions 1-5 in your notebook and the answers  III.  Classwork A.   […]