Google Sheets Test Google Sheets Pivot Tables for Analysis 5

Question 1

What does the 'Repeat row labels' option accomplish in a pivot table with nested rows?

Accepted Answer

It fills the grouping label on every detail row instead of only the first

Answer

'Repeat row labels' shows the parent group value on each nested row, which is useful for exporting flat data.

Question 2

A calculated field named Margin uses ='Profit'/'Revenue'. Why might it show errors for some rows?

Accepted Answer

Revenue could be zero, causing division by zero

Answer

Dividing by a Revenue value of zero produces a #DIV/0! error in the calculated field.

Question 3

Which is the most reliable way to make a pivot table automatically include future rows of data?

Accepted Answer

Define the source using whole columns (e.g., A:D) or a named/auto-expanding range

Answer

Referencing entire columns (or a dynamic named range) lets the pivot table capture new rows automatically.

Question 4

You want to compare this year's monthly sales side by side with last year's. What is a good pivot approach?

Accepted Answer

Put Month in Rows and Year in Columns with SUM of Sales

Answer

Month in Rows and Year in Columns creates a side-by-side year-over-year comparison of monthly sales.

Question 5

When a pivot table's Values area shows numbers with too many decimals, how do you fix the display?

Accepted Answer

Apply number formatting to the pivot table's value cells

Answer

You can apply standard number formatting to the pivot table's value cells to control decimal display.

Google Sheets Test Practice Test