PivotTable Flashcards Preview

ISYS 201 > PivotTable > Flashcards

Flashcards in PivotTable Deck (6)
Loading flashcards...
1
Q

When are PivotTables used?

A

-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
2
Q

What are the 4 regions/areas of the PivotTable?

A

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

3
Q

Data area

A

contains the data that you would like to calculate

4
Q

Row Area

A

(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

5
Q

Column Area

A

(stretches along the top of the PivotTable)

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

6
Q

Page Area

A

(located at the upper left hand corner)

-allows you to filter data