I.  Bellwork Explain the difference between a relative cell reference and an absolute cell reference? II.  Objectives: Create and Format spreadsheets Sort data and create functions for mathematic operations III.  Chapter 6 Test on iLearn A.  Pages 285-286  Exercise 9 B.  Chapter 6 iLearn Test

I.  Bellwork A.  Write a formula which will average the numbers in cell C1 to C14 and round them to the second decimal place (hundredths). B.  Write a formula which will add up the numbers in cell C1 to C14 and round them to the first  decimal place (tenths). II.  Objectives: Using the PMT Function […]

I.  Bellwork Answer the questions on iLearn II.  Objectives: Formatting and entering formulas on a worksheet Using the PMT Function to determine loan payments III.  Classwork A.  Page 278 Exercise 2 B.  Page 279 Exercise 4

I.  Bellwork Page 276 #20 B II.  Objectives: Use functions to perform calculations Inserting row/columns III.  Classwork A.  P. 275 Questions & Answers 10-16 & 18 -Print Off B.  Pgs 277-Exercise 1 C.  Excel Function Quiz on iLearn

I.  Bellwork Page 276 #27 A & B II.  Objectives: Use functions to perform calculations Inserting row/columns III.  Classwork A.  Pgs 269-271 Fundraiser(Skip Direction 3b) B.  P. 275 Questions & Answers 10-16 & 18

I.  Bellwork List the arguments found in an IF Function Provide an example of an IF Function II.  Objectives: Copy and move data between sheets Create What-If Statements III.  Classwork A.  Pgs 265-267 Car Sales B.  Pgs 269-271 Fundraiser

I.  Bellwork List and describe 5 different functions contained on the function list. II.  Objectives:         Use functions to perform calculations Copy and move data between sheets III.  Classwork A.  Pgs.  262-264 Loan B.  Pgs 265-267 Car Sales

I.  Bellwork A.  Draw and Label the following buttons: AutoSum Sort A to Z Sort Z to A Sort II.  Review Absolute Cell References & Formulas III.  Objectives: Use functions to perform calculations Delete Columns Add IF Functions IV.  Classwork A.  Pgs 259-261 Payroll Part 1 B.  P. 275 Questions & Answers 1-3 & 5-9

I.  Bellwork A. What is an absolute cell reference? B. Provide an example of an absolute cell reference II.  Objectives: Use functions to perform calculations Apply sorting to documents III.  Classwork A.  Pgs.  255-256 Planets Part 2 B.  P. 275 Questions & Answers 1-3 & 5-9