Files Submitted

0

1. Complete Project 2 of the Microsoft Excel 2003 book. (See FIGURE 2-1 on page EX 66 for example of completed Project 2 worksheet). Include a header using the instructions below*. Check your worksheet by using the Show formulas feature**.
2. Name the second sheet Real-Time Stock Quotes. Include a header on the printout*.

2

3. Complete In the Lab 2: Accounts Receivable Worksheet on pages EX 134 of the Microsoft Excel 2003 book. Name the second file Revised Lab 2-2 Custom Home Theater Monthly Accounts Receivable. 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, click inside the Center Section box, and then click the Date button (it looks like two calendar pages). Finally, click inside the Right Section box and type your name. 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 7, Your Name" in the Subject.

Files to be submitted as attachments:

1. Lab 2-2 Custom Home Theater Monthly Accounts Receivable (Formula View) with Bar Chart as sheet 2.
2. Revised Lab2-2 Custom Home Theater Monthly Accounts Receivable (Bar Chart)