Google Sheets Pivot Tables for Analysis Flashcards

You have a pivot table summarizing sales by month and region. Which combination best answers 'which region grew fastest'?

Answer: Rows = Region, Columns = Month, Values = SUM of Sales

Placing Region in Rows and Month in Columns with summed Sales lets you compare each region's trend across months.

What is the quickest way to turn a pivot table summary into a visual chart in Google Sheets?

Answer: Select the pivot table and use Insert > Chart

Selecting the pivot table and choosing Insert > Chart builds a chart directly from the summarized data.

A stakeholder wants average order value per customer segment. Which Values setup is correct?

Answer: Order Value summarized by AVERAGE, with Segment in Rows

Averaging Order Value with Segment as the row field yields the average order value per segment.

Which situation would make a pivot table the wrong tool compared to a simple formula?

Answer: You need a single total of one column with no grouping

For a single ungrouped total, a SUM formula is simpler and faster than building a pivot table.

In a pivot table with Region in Filters, selecting multiple regions does what?

Answer: Includes data from all selected regions combined

Selecting multiple filter values includes all chosen regions in the summarized results.

You duplicate a sheet containing a pivot table. What happens to the copied pivot table's source reference?

Answer: It may still reference the original data range depending on how the range was defined

A duplicated pivot table can retain a reference to the original range, so you should verify the data source after copying.

Which action best isolates the top 5 products by revenue in a pivot table?

Answer: Sort by SUM of Revenue descending and use a row-field value filter to limit items

Sorting by revenue descending combined with a value filter on the row field surfaces the top products cleanly.