Activity 5A- Spreadsheet
1. Launch the application Microsoft Excel
2. You will create a spreadsheet document by doing the
following.
3. Set up cell A1 as NAME (UC)
4. Set up cells B1-G1 as Jan-Jun (UC)
5. Add six names in cells A3-A8 (Last, First)
6. Enter sales figures for each person for all 6 months.
7. Set up column H as Total (Sum Formula)
8. Set up row 10 as TOTALS (UC) (Sum Formulas).
9. Set column I as commission: Formula is Example
=H3* .25
10. Set row 12 as AVERAGE (UC): Average( )
11. For all cells that have numbers in them set the cell attributes
to dollar/currency with two decimals and commas.
12. Make sure you have selected to print to the laser printer.
13. Go to the menu View and select Header (it is in
print setup on the Macintosh)
14. For the header type in the following: Name, Date, Period,
Station, Activity
15. From the File menu select Page Setup and select landscape.
16. Adjust cell widths to print 8 1/2 by 11
17. You must select the area to
print and go to the Format menu and select Format Cells.
18. Select the Borders tab and then select Inside and Outside. This will
print a grid.
19. Save this document to your disk. You will need it again.
20. Print and turn in your Spreadsheet.