PivotTable

Question 1

When are PivotTables used?

Answer 1

-most beneficial when you have large datasets or a variety of planned or unplanned types of analysis to perform

1. You have a large set of transactional information that needs to be analyzed in a variety of ways, or you expect frequent change requests to your analysis
2. You need to find relationships, groupings, or trends using various time periods within your data
3. You need to find a list of unique values for one field in your data
4. You require new additions to subtotals
5. You need to organize information into a format that is easy to read

Question 2

What are the 4 regions/areas of the PivotTable?

Answer 2

-row area, column area, data area, and page area

Question 3

Data area

Answer 3

contains the data that you would like to calculate

Question 4

Row Area

Answer 4

(appears down the left of the PivotTable)
-the types of data you want to drop here are things you want to GROUP or CATEGORIZE, such as PRODUCTS, LOCATION, or NAMES

Question 5

Column Area

Answer 5

(stretches along the top of the PivotTable)

-types of data: trend, side-by-side (ex: months)

Question 6

Page Area

Answer 6

(located at the upper left hand corner)

-allows you to filter data