Pivot Tables Flashcards by A Y | Brainscape

Q

What is a pivot table?

A

Tool to summarize data
Help convey info easly

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

How to create a pivot table? & How to select the data?

A

Inserst > Pivot Table
Ctrl+Shift+→+↓

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What are the components of a pivot table?

A

Rows
Columns
Values
Filters

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

How to create a calculated field?

A

PivotTableAnalyze > Fields, Items,.. > Calculated Field

How well did you know this?

1

Not at all

2

3

4

5

Perfectly