Creating Campus Calculations

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.

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.