Google Sheets Test Google Sheets Pivot Tables for Analysis 3

Question 1

A pivot table calculated field lets you do what?

Accepted Answer

Create a new value using a formula based on existing source columns

Answer

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?

Accepted Answer

By typing the field name Revenue directly

Answer

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?

Accepted Answer

MEDIAN

Answer

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?

Accepted Answer

Genuine date values, not text that looks like dates

Answer

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?

Accepted Answer

Whether a subtotal row appears for that grouping

Answer

The 'Show totals' option toggles the subtotal row for that particular grouped field.

Google Sheets Test Practice Test