Google Sheets Test Google Sheets Pivot Tables for Analysis 3 — Questions and Answers
Question 1: A pivot table calculated field lets you do what?
- Create a new value using a formula based on existing source columns (Correct answer)
- Add rows to the source data
- Change the font of the table
- Filter out blank cells automatically
Correct 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.
Question 2: In a calculated field formula, how do you reference the 'Revenue' source column?
- By typing the field name Revenue directly (Correct answer)
- By using A1-style cell references
- By using =IMPORTRANGE
- By using the column letter only
Correct answer: By typing the field name Revenue directly
Calculated fields reference source columns by their header name, such as Revenue, not by cell address.
Question 3: Which summarize function gives you the middle value of a group, unaffected by extreme outliers?
- MEDIAN (Correct answer)
- AVERAGE
- SUM
- COUNT
Correct answer: MEDIAN
MEDIAN returns the middle value and is not skewed by outliers the way AVERAGE is.
Question 4: You group a Date field in a pivot table by month. What must the source column contain for this to work correctly?
- Genuine date values, not text that looks like dates (Correct answer)
- Only whole numbers
- Currency-formatted values
- Text labels
Correct 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.
Question 5: What does the 'Show totals' checkbox for a row field control?
- Whether a subtotal row appears for that grouping (Correct answer)
- Whether the pivot table has a title
- Whether values are shown as percentages
- Whether the source data is sorted
Correct answer: Whether a subtotal row appears for that grouping
The 'Show totals' option toggles the subtotal row for that particular grouped field.
Question 6: If you want the highest-selling product to appear at the top of a pivot table, what should you configure?
- Sort the row field by the SUM of Sales, descending (Correct answer)
- Alphabetize the row field
- Apply a color scale
- Add the product to the Filters area
Correct 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.
Question 7: Which of these is a valid reason a pivot table shows '(blank)' as a row category?
- Some source rows have an empty cell in that field (Correct answer)
- The pivot table is corrupted
- You used the wrong summarize function
- The chart failed to load
Correct 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.
Google Sheets Test Google Sheets Pivot Tables for Analysis 3
A pivot table calculated field lets you do what?