Google Sheets Test Google Sheets Pivot Tables for Analysis 2 — Questions and Answers
Question 1: In a pivot table, which area determines the horizontal categories that spread across the top of the summary?
- Columns (Correct answer)
- Rows
- Values
- Filters
Correct answer: Columns
Fields placed in the Columns area create category headers spread horizontally across the top of the pivot table.
Question 2: What happens to a pivot table when you add a new row to the underlying source data range that was defined with a fixed range like A1:D50?
- The new row is not included until you edit the data range (Correct answer)
- The pivot table auto-expands to include it instantly
- The pivot table breaks and shows an error
- Google Sheets deletes the old pivot table
Correct answer: The new row is not included until you edit the data range
A fixed range does not grow automatically, so new rows outside A1:D50 are excluded until the data range is updated.
Question 3: Which summarize-by function should you choose in the Values area to display the number of entries rather than their total?
- COUNTA (Correct answer)
- SUM
- AVERAGE
- MAX
Correct answer: COUNTA
COUNTA counts the number of non-empty entries, which shows how many records exist per category.
Question 4: You want a pivot table to show only sales from the 'West' region without altering the source data. Where should you place the Region field?
- Filters (Correct answer)
- Values
- Columns
- Rows
Correct answer: Filters
The Filters area lets you restrict the whole pivot table to selected values like 'West' without changing source data.
Question 5: After creating a pivot table, the source data changes. What must you do to reflect the updates?
- Nothing — pivot tables refresh automatically when source data changes (Correct answer)
- Manually click a Refresh button every time
- Rebuild the pivot table from scratch
- Export and re-import the data
Correct answer: Nothing — pivot tables refresh automatically when source data changes
Google Sheets pivot tables update automatically whenever the referenced source data changes.
Question 6: Which feature lets you show each value as a percentage of the grand total inside a pivot table?
- The 'Show as' option set to % of grand total (Correct answer)
- Conditional formatting
- The TEXT function
- A separate chart
Correct answer: The 'Show as' option set to % of grand total
The 'Show as' setting in the Values area can display figures as a percentage of the grand total.
Question 7: What is the effect of adding two fields to the Rows area of a pivot table?
- It creates a nested, grouped hierarchy of the first field then the second (Correct answer)
- It replaces the first field with the second
- It merges both fields into one column
- It causes an error
Correct answer: It creates a nested, grouped hierarchy of the first field then the second
Multiple row fields create a nested hierarchy, grouping the second field within each value of the first.
Google Sheets Test Google Sheets Pivot Tables for Analysis 2
In a pivot table, which area determines the horizontal categories that spread across the top of the summary?