Google Sheets Test Google Sheets Pivot Tables for Analysis 4

Question 1

You have a pivot table summarizing sales by month and region. Which combination best answers 'which region grew fastest'?

Accepted Answer

Rows = Region, Columns = Month, Values = SUM of Sales

Answer

Placing Region in Rows and Month in Columns with summed Sales lets you compare each region's trend across months.

Question 2

What is the quickest way to turn a pivot table summary into a visual chart in Google Sheets?

Accepted Answer

Select the pivot table and use Insert > Chart

Answer

Selecting the pivot table and choosing Insert > Chart builds a chart directly from the summarized data.

Question 3

A stakeholder wants average order value per customer segment. Which Values setup is correct?

Accepted Answer

Order Value summarized by AVERAGE, with Segment in Rows

Answer

Averaging Order Value with Segment as the row field yields the average order value per segment.

Question 4

Which situation would make a pivot table the wrong tool compared to a simple formula?

Accepted Answer

You need a single total of one column with no grouping

Answer

For a single ungrouped total, a SUM formula is simpler and faster than building a pivot table.

Question 5

In a pivot table with Region in Filters, selecting multiple regions does what?

Accepted Answer

Includes data from all selected regions combined

Answer

Selecting multiple filter values includes all chosen regions in the summarized results.

Google Sheets Test Practice Test