Files Submitted

0

1. Complete Project 1 of the Microsoft Excel 2003 book. (See FIGURE 1-1 on page EX 5 for example of completed Project 1 worksheet). Include a header using the instructions below*. Check your worksheet by using the Show formulas feature**.

2

2. Complete In the Lab 1: Quarterly Sales Analysis Worksheet on page EX 58 of the Microsoft Excel 2003 book. Name the second file Revised Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter. Include a header using the instructions below*. Check your worksheet by using the Show formulas feature**.

2 attachments

Click View on the Menu Bar and select the option Header and Footer. Click the Custom Header button in the Header/Footer dialog box. Click inside the Left Section box and click the Filename button (it looks like a page with the Excel logo on it). Next, press the Enter key, and then click the Date button (it looks like two calendar pages). Finally, click inside the Right Section box and type your name, press Enter key, and type your section number. Click OK.

After each time your print, hold down the Ctrl + ` (which is the symbol just above the Tab key). Excel will display the formulas you used in your document. After it does this, click File on the Menu Bar, and choose Page Setup. Click the Landscape radio button under Orientation, and choose the Fit To: radio button under Scaling. Click the Print button in the upper right-hand corner. Hold down Crtl + ` to remove the formulas from view.

Note:

• Type the header on your worksheet as instructed.
• Save all the files on your disk first before you email your instructor.
• Browse the files on your disk and select/attach 2 files to your email.
• Type "Your section #, Assignment 6, Your Name" in the Subject.

Files to be submitted as attachments:

1. Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter (Formula View)
2. Revised Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter