Create an excel worksheet solving the rubric

  • Calculate Total Enrollment for each location and the Grand Total
  • Calculate Percent of Total (Total Enrollment divided by Grand Total). Be sure to use absolute cell references.
  • Create a bar chart to show the data for each location. (Do not use any of the calculations.) Move the chart to its own sheet.
2 In cell D9, find the house payment using the PMT function and cell references.
3 Using the data in column D, use the Goal Seek function to determine how many months it will take to save $5,500.
4 Filter the data based on Social Statistics.
5 Sort the data on Topic, and within Topic, sort on Sub Topic.
6 Create a Pivot Table for Artist, Location, and Value. Let Excel decide where these fields will go. Have Excel put the table on a separate sheet.

Homework Writing Bay
Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper