Computer Applications – 4/20/12
I. Bellwork
- On iLearn
II. Objectives:
- Using the PMT Function to determine loan payments
- Sort data and create functions for mathematical operations
III. Classwork
A. Pages 279-280 Exercise 4 (See example on page 261)
B. Pages 285-286 Exercise 9
IV. Chp 6 Test Monday
- Review your old Bellwork on iLearn
- Be able to sort data
- Insert columns
- Know how to create and use absolute values: $A$3
- Know how to create formulas to multiply and subtract values in different cells
- Be able to use functions to sum and average columns and rows of numbers
- Know how to write a round numbers in a formula
- Ex: =Round(Average(D1..D13),1)
- Be able to write an IF Function
- Show formulas
Leave a Reply