Scenario: Your dean has asked you to create an Excel sheet so that she can compare the student enrollment in four Rasmussen campuses.
Calculations
Start a new Excel worksheet and type in the following:
In cell:
Type:
A1
Rasmussen Students
A2
Insert Your Name
A5
Campus
A6
Ocala
A7
Aurora
A8
Romeoville
A9
Ft. Meyers
A10
Total
B5
Q1
B6
900
B7
550
B8
400
B9
350
C5
Q2
C6
850
C7
600
C8
550
C9
500
D5
Q3
D6
875
D7
700
D8
650
D9
625
E5
Total
F5
Average
G5
% of Total
Using the AutoSum function, calculate the totals for each branch in Column E.
In row 10, using the AutoSum feature, calculate the totals for columns B through E.
Using the Average function, calculate the average student population in Column F.
Calculate the % of Total for each campus in Column G. (Hint: use the total in cell E10 as part of this calculation.)
Format the % of Total by clicking the % sign on the ribbon.
Formatting
Merge and center the title over the data columns.
Merge and center the subtitle over the data columns.
Bold the title and subtitle
Format the column headers to be bold and a different color.
Bold the data in row 10.
Remove the decimal places in column F.
Charting
Using only the data from columns A through D and rows 5 through 9, create a 3-D Bar chart.
Move the chart to its own sheet. Name the sheet My Bar Chart.
Save the file.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|