Select Page

Rasmussen College The House Payment Total Enrollment Worksheet

Question Description

  • 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.

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you "A" results."

Order Solution Now