Help me study for my Excel class. I’m stuck and don’t understand.

Exercise 1:

*You have a list of repeating group names.

*Using a pivot table, count how many times each group name appears in the list.

*Keep pivot table in this tab.

Notice that this pivot table is a list comprised of each group name only occurring once.

Then, within the pivot table, put the list in decreasing order based on the number of times the name appears in the list.

Exercise 2

There are preset 3 segments that all groups are put into:

Big

Medium

Tiny

Using a pivot table, create a table displaying Revenue for each segment.

Keep pivot table in this tab.

Large $ amounts (over $100 or so) are typically shown with zero decimals.

Exercise 3

Make a pivot table showing each segments revenue and expenses.Make sure to use both row headers and column headers.Have “Sum of Member Months” be the left most column.

Format the cells with dollar signs ($) and no decimal places.

Keep the table in this tab.

Exercise 4

Create a column entitled “Net Income/Loss.”This column will represent Revenue minus Expenses.

Make a pivot table representing Each Segment and Subdivision by Revenue, Expenses, and Net Income.Use row headers and column headers.

Keep pivot table in this tab.

5

Make a pivot table of Expenses by Service Month and Paid Month for just the “Big” group segment.

Keep pivot table in this tab.

The result is referred to as a Claims Lag Triangle.

please see attach for the excel file