Scenario: Your dean has asked you to create an Excel sheet so that she can compare the student enrollment in four Rasmussen campuses.
Start a new Excel worksheet and type in the following:
Insert Your Name
% 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.
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.
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.