EXCEL STUDY CASE

Excel Case 2

Complete the pivot table on the Pivot Tables cont. tab in the Advanced Excel Workshop spreadsheet.  Complete the Basic Exercise: Recreate the Pivot Table/Chart with all features included. This time, summarize on Vehicle Class. When summarized in the pivot, make sure these numbers are sorted from lowest to highest. What is the data telling you?

Rubric:

Attempt (1)

By Vehicle Class (1)

Sorted by lowest to highest relativity (1)

Includes Claim per policy and relativity (1)

Graph (1)

State filter (1)

Headings look good (1)

What is the data telling you (1)

Formatted appropriately (2)