Assignment 15

Volume I

EXCEL CHAPTER 3

Spreadsheets in Decision Making: What If?

(Volume I, third chapter on the section with green page number flags)

·        Do Knowledge Test K15 at the beginning of the class. Do Skill test S15 “Excel Chapter 3” near the end of class. Make sure “S02” is used as the ID for the skill test. 

1.    Read pages 86 to 89

2.    Do Hands-on Exercise 1: Analysis of a Car Loan, steps 1 to 5

a.     Step 5:

i.     Add your name to the footer: View > Header and Footer > Custom Footer > Type your name in the left section. 

ii.    Print both the Worksheet and the Formulas, (Ctrl  ` ) make sure you can read the values on all cells. Hand in your printouts as part of your assignment 15.

3.    Read pages 93 to 97

4.    Do Hands-on Exercise 2: Mortgage Analysis, steps 1 to 9

a.     Step 9:

i.     Add your name to the footer.

ii.    Print both the Worksheet and the Formulas, (Ctrl  ` ) make sure you can read the values on all cells. Hand in your printouts as part of your assignment 15.

5.    Read pages 105 to 114

6.    Do Hands-on Exercise 3: The Expanded Grade Book, steps 1 to 10 and 13

a.     Skip steps 10, 11 and 12

b.     Step

c.     Step 13:

i.     Add your name to the footer.

ii.    Print both the Worksheet and the Formulas, (Ctrl  ` ) make sure you can read the values on all cells. Hand in your printouts as part of your assignment 15.

7.    Do problems 1 on page 128

a.     Add your name to the footer.

b.     Print both the Worksheet and the Formulas, make sure you can read the values on all cells, and that your printouts fit on one page. Hand in your printouts as part of your assignment 15.

8.    Staple and turn in your printouts. Use this sheet as cover adding your section number, name and computer number.

FOR NEXT CLASS:  BRING VOLUME I

READ EXCEL CHAPTER 4 Graphs and Charts: Delivering a Message

(Volume I, fourth chapter of section with green page number flags)

Read pages 138 to 148; 158 to 161; 168 to 169; and pages 178 to 182