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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Follow this blog

Get every new post delivered right to your inbox.




Skip to toolbar