PivotTable formatting in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a PivotTable in Google Sheets?

A PivotTable is a tool that helps you quickly summarize and analyze large sets of data by organizing it into a simple table format. It lets you group, count, and total data without changing the original data.

beginner

How do you change the number format in a PivotTable?

Click on a value in the PivotTable, then go to the 'Pivot table editor' on the right. Under 'Values', click the dropdown next to the field, and select 'Number format' to pick how numbers appear (like currency, percentage, or decimal places).

intermediate

What does 'Show as' option do in PivotTable formatting?

The 'Show as' option changes how the numbers are displayed, like showing values as a percentage of the row, column, or grand total. This helps you understand proportions easily.

intermediate

How can you apply conditional formatting to a PivotTable?

Select the PivotTable cells you want to format. Then go to Format > Conditional formatting. Set rules like 'greater than' or 'text contains' to highlight cells with colors based on their values.

beginner

Why is refreshing a PivotTable important after changing source data?

Refreshing updates the PivotTable to show the latest data from your source. Without refreshing, the PivotTable might show old or incorrect summaries.

Where do you find the option to change number formats in a Google Sheets PivotTable?

A In the Pivot table editor under 'Values'

B In the main menu under 'File'

C By right-clicking the sheet tab

D In the toolbar under 'Insert'

Number formats are changed in the Pivot table editor by selecting the value field and adjusting its settings.

What does the 'Show as' feature in PivotTables help you do?

A Sort the data alphabetically

B Change the font size of the table

C Display values as percentages of row, column, or total

D Add new rows to the source data

'Show as' changes how values are displayed, such as showing percentages relative to rows, columns, or totals.

How do you apply conditional formatting to a PivotTable?

A Select cells and use Format > Conditional formatting

B Right-click and choose 'Format cells'

C Use the 'Data' menu to add formatting

D Conditional formatting is not available for PivotTables

Conditional formatting can be applied by selecting cells and using the Format menu option.

What happens if you don't refresh a PivotTable after changing the source data?

A The PivotTable updates automatically

B The PivotTable shows old data and summaries

C The source data is deleted

D The PivotTable deletes itself

Without refreshing, the PivotTable keeps showing old data and does not reflect changes.

Which of these is NOT a way to format a PivotTable?

A Changing number formats

B Applying conditional formatting

C Using 'Show as' to display percentages

D Changing the sheet tab color

Changing the sheet tab color does not affect PivotTable formatting.

Explain how to change the number format of values in a Google Sheets PivotTable.

Look for the settings next to the value fields in the editor.

Describe how conditional formatting can help make a PivotTable easier to understand.

Think about how colors can guide your eyes to key data.