PivotTable layouts in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a PivotTable layout in Excel?

A PivotTable layout is the way data is arranged and displayed in a PivotTable. It controls how rows, columns, and values are organized to summarize data clearly.

beginner

Name the three main PivotTable layout options in Excel.

The three main PivotTable layouts are: Compact Form, Outline Form, and Tabular Form. Each shows data differently for easier reading or analysis.

beginner

What does the Compact Form layout do in a PivotTable?

Compact Form shows all row fields in one column, making the table smaller and easier to read when space is limited.

intermediate

How does the Outline Form layout differ from Compact Form in a PivotTable?

Outline Form shows each row field in its own column, making it easier to see the hierarchy and separate data clearly.

intermediate

What is the benefit of using Tabular Form layout in a PivotTable?

Tabular Form displays data in a table with each field in its own column and includes subtotals at the top of each group, making it easy to export or analyze further.

Which PivotTable layout shows all row fields in a single column?

A Classic Form

B Outline Form

C Tabular Form

D Compact Form

Compact Form arranges all row fields in one column to save space.

In which layout does each row field get its own column?

A Outline Form

B Compact Form

C Tabular Form

D None of the above

Outline Form separates row fields into individual columns.

Which layout is best for exporting PivotTable data to another program?

A Tabular Form

B Compact Form

C Outline Form

D Summary Form

Tabular Form shows data in a clear table format, ideal for exporting.

Where can you change the PivotTable layout in Excel?

A PivotTable Analyze tab > Options

B Design tab > Report Layout

C Home tab > Format

D Data tab > Sort

The Design tab has the Report Layout option to change PivotTable layouts.

What does the Tabular Form layout add that Outline Form does not?

A Collapsed groups

B All fields in one column

C Subtotals at the top of groups

D No subtotals

Tabular Form includes subtotals at the top of each group.

Explain the differences between Compact, Outline, and Tabular PivotTable layouts.

Think about how the data is arranged and how easy it is to read or export.

Describe how to change the layout of a PivotTable in Excel.

Look for layout options under the PivotTable Design tab.