Homework 3

CS14F

50 pts., due Nov. 5

1. Excel Essentials, end of Project 4, Brief Cases Checking Sales Figures. Print one copy of the spreadsheet showing values and a second copy showing formulas. To print formulas:
   1. From the Tools menu choose options.

   2. Click the View tab.

   3. Under Window Options click Formulas. You should see an ``X'' appear in the box to the left of Formulas.

   4. Click OK.

   5. Formulas should now be displayed.

   6. From the File menu choose Page Setup.

   7. Click the Page tab and choose Landscape. Click OK.

   8. Print the spreadsheet.

   When finished printing formulas, repeat this process to return to the values display.

2. Excel Essentials, end of Project 6, Brief Cases Creating a Chart to Show Mail Order Sales. Print one copy of the spreadsheet, including the chart.

Turn in the spreadsheets you printed.