At the end of this lesson students will be able to: (Objectives)

•  Modify and create cell styles.
•  Insert and delete rows and columns.
•  Use the SUM, AVERAGE, MAX, MIN, and ROUND functions.
•  Understand absolute cell references.
•  Identify common error values
• Sort the data in a worksheet.
• Use the IF function.
• Change the print orientation and margins of a worksheet.
• Print part of a worksheet.
• Create an amortization table using the PMT function.
• Organize data using multiple sheets in a workbook.
•  Determine how changing data impacts results by asking “What-If”questions.

 Assignments:

1.       Complete all practices.  Participate in the Student Practice on overhead.

2.       Complete the following exercises for a screen grade

Pizza Palace - Ex 2

School Loan – Ex 3

Car Loan – Ex 4

3.       Review  on line and and Test online TBA