Skills Needed:
- Enter data
- Use SUM function
- Use Average function
- Apply formatting and cell styles
- Format data as a table
- Merge and Center cells
- Use conditional formatting
- Create chart
- Change page orientation
- Adjust column widths
- Insert headers and footers
- Print
Create a spreadsheet for the following data:
SEMIANNUAL CUSTOMER SALES ANALYSIS
|
|
|
|
|
Customer
|
January
|
February
|
March
|
April
|
May
|
June
|
Average
|
Lakeside Trucking
|
89,450
|
75,340
|
98,224
|
84,231
|
73,455
|
97,549
|
|
Gresham Machines
|
45,210
|
28,340
|
53,400
|
33,199
|
40,390
|
50,112
|
|
Real Photography
|
30,219
|
28,590
|
34,264
|
30,891
|
35,489
|
36,400
|
|
Genesis Productions
|
65,290
|
51,390
|
79,334
|
72,190
|
75,390
|
83,219
|
|
Landower Company
|
12,168
|
19,355
|
45,209
|
22,188
|
14,228
|
38,766
|
|
Jewell Enterprises
|
44,329
|
21,809
|
33,490
|
19,764
|
50,801
|
32,188
|
|
Total
|
|
|
|
|
|
|
|
1. Calculate the average sales for each company in column H.
2. Calculate Monthly Totals in row 9. Format row 9 using the “total” cell style. (You don’t need a total for the averages).
3. Use conditional formatting to change the format for average sales above $48,000.
4. Format the data as the table of your choice.
5. Make a graph for the data on the same sheet.
6. Make sure all information in the spreadsheet and graph is labeled.
7. Make sure your data is centered in the columns and easy to read. Adjust column widths if necessary.
8. Format the spreadsheet for an attractive, easy to read appearance.
9. The spreadsheet and graph should be on one page. Use landscape format to make it fit if you need to.
10. Put your name on the top of the spreadsheet using a header. Put "CIS110" and the date on the bottom center of the spreadsheet using a footer.
Print your spreadsheet and put it in your portfolio.
|