CGS 1570

Excel Chapter 3

Assignment 8 

Name: ______________________________ Section (Time/Day): ________________________

All printouts should be in values view. Printouts
Note: 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 in the directory Excel Volume 1, 1/e at http://www.prenhall.com/exploring.

 
1.

Complete Hands-On Exercise 1 (pp. 443-449)

At Step 5 print Sheet 1 on p. 447

At Step 6 print Sheet 1 on p. 448

At Step 7 print Chart 1 on p. 449

3
2.

Complete Hands-On Exercise 2 (pp. 454-458)

At Step 2 print Revenue By City sheet on p. 455

At Step 6 print Revenue by Product sheet on p. 458

2
3.

Complete Hands-On Exercise 3 (pp. 462-467)

At Step 7 print the memo with embedded chart on p. 466

At Step 8 print the chart on p. 467

At Step 9 print the web page on p. 467

3
4.

Complete Practice Exercise 1 (pp. 471-472)

At Step g print the web page on p. 472

At Step h print the workbook (all sheets: 1, 2, and 3) on p. 472

4
5.

Complete Midlevel Exercise 4 on p. 480

At Step i print the worksheet with graph on p. 480

1
  • Header - Left section: your name; Center section: your section (Time/Day); Right section: page number.
  • Footer - Center section: Lemley; Right section: today's date.
  • Format each printout to fit on one page.
  • Staple your printouts in order.
  • Attach cover page when submitting the assignment.