CGS 1570

Chapter 7: Creating a Worksheet and Charting Data

Assignment 6

Name: ______________________________ Section (Time/Day): ________________________

  • Download the files required for the text and store them on your media (preferably a USB drive).

  • The files required for this assignment are found on the Teacher drive.

Number
of
Printouts
1.

Complete Activity 1.01 – Activity 1.16 in Project 1A (pp. 318-343).
Print the value view of 1A_Quarterly_Sales in Step 3 on p. 342 and the formula view of 1A_Quarterly_Sales in Step 6 on p. 343.

 2
2. Complete Activity 1.17 – Activity 1.24 in Project 1B (pp. 344-359).
Print the value view of 1B_Car_Products and the formula view of 1B_Car_Products in Step 17 on p. 359.		 2
3.

Complete Mastering Excel, Project 1E Hard Drives (pp. 368-369).

Print the value view of 1E_Hard_Drives and the formula view of 1E_Hard_Drives in Step 12 on p. 369.		 2
4. Complete Mastering Excel, Project 1G Sales Comparison (pp. 372-373). Print the value view of 1G_Sales_Comparison and the formula view of 1G_Sales_Comparison in Step 14 on p. 373. 2

Staple your printouts in order and attach cover page when submitting the assignment.