Semiannual Sales

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.

 

lmayer@elgin.edu