Google Sheets Pivot Tables for Analysis Flashcards

A pivot table calculated field lets you do what?

Answer: Create a new value using a formula based on existing source columns

A calculated field creates a new value column derived from a formula referencing existing source fields.

In a calculated field formula, how do you reference the 'Revenue' source column?

Answer: By typing the field name Revenue directly

Calculated fields reference source columns by their header name, such as Revenue, not by cell address.

Which summarize function gives you the middle value of a group, unaffected by extreme outliers?

Answer: MEDIAN

MEDIAN returns the middle value and is not skewed by outliers the way AVERAGE is.

You group a Date field in a pivot table by month. What must the source column contain for this to work correctly?

Answer: Genuine date values, not text that looks like dates

Date grouping requires real date values; text formatted to look like dates cannot be grouped by month.

What does the 'Show totals' checkbox for a row field control?

Answer: Whether a subtotal row appears for that grouping

The 'Show totals' option toggles the subtotal row for that particular grouped field.

If you want the highest-selling product to appear at the top of a pivot table, what should you configure?

Answer: Sort the row field by the SUM of Sales, descending

Sorting the row field by the aggregated Sales value in descending order puts the top seller first.

Which of these is a valid reason a pivot table shows '(blank)' as a row category?

Answer: Some source rows have an empty cell in that field

Empty cells in the grouped source column appear as a '(blank)' category in the pivot table.