Google Sheets Test Google Sheets Pivot Tables for Analysis 2

Question 1

In a pivot table, which area determines the horizontal categories that spread across the top of the summary?

Accepted Answer

Columns

Answer

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?

Accepted Answer

The new row is not included until you edit the data range

Answer

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?

Accepted Answer

COUNTA

Answer

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?

Accepted Answer

Filters

Answer

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?

Accepted Answer

Nothing — pivot tables refresh automatically when source data changes

Answer

Google Sheets pivot tables update automatically whenever the referenced source data changes.

Google Sheets Test Practice Test