Assignment 17

Volume II

EXCEL CHAPTER 6

Consolidating Data: 3-D Workbooks and File Linking

(Volume II, second chapter on the section with green page number flags)

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

1.    Read pages 250 to 253

2.    Do Hands-on Exercise 1: Copying Worksheets, steps 1 to 5

a.     Step 5: Do not print at this point

3.    Read pages 259 to 261

4.    Do Hands-on Exercise 2: 3-D References, steps 1 to 7

a.     Step 7: Add your name to the footer

b.     Step 7: Print all four Workbooks. Hand in your printouts as part of your assignment 17.

5.    Read page 269

6.    Do Hands-on Exercise 3: The Documentation Worksheet, steps 1 to 5

a.     Step 5: Add your name to the footer

b.     Step 5: Print your document and hand it in as part of your assignment 17.

7.    Read page 275

8.    Do Hands-on Exercise 4: Linked Workbooks, steps 1 to 5

a.     Step 5: Add your name to the footer

b.     Step 5: Print out the Corporate Links Workbook, and hand it in as part of your assignment 17.

9.    Do Practice 1 on page 283. Before you print, enter your name and computer # in the header of every sheet in the workbook.

10.  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 ACCESS CHAPTER 1 Introduction to Microsoft Access: What is a Database?

(Volume I, first chapter of section with orange page number flags)

Read pages 2 to 5, 13 to 16, 25 to 26, and 32 to 33