Introduction to FP&A: Excel Pivot Table Investigation

What is the main purpose of a pivot table in Excel?

• Create macros

• Store large amounts of data

• Summarize and analyze data

• Format worksheets

What type of analysis are pivot tables especially useful for?

• Image editing

• Interactive dashboards

• Large dataset summarization

• Website development

What are the four main areas of a pivot table?

• Filters, Labels, Text, Charts

• Rows, Columns, Filters, Values

• Headers, Footers, Cells, Data

• Index, Array, Table, Chart

What does the “Filter” section in a pivot table do?

• Hides data permanently

• Deletes extra columns

• Refines data shown in the pivot table

• Adds charts automatically

Which field is used to show totals like sums or averages in pivot tables?

• Rows

• Columns

• Filters

• Values