Free Practice Quiz Question List

8 Pivot Tables and Data Summaries Online Quiz Questions

Use this free practice quiz with 20 questions to review 8 Pivot Tables and Data Summaries, test your knowledge, and prepare for your next test or exam.

20 questions

Choose one

1 point

Which source-data layout is best prepared for creating a pivot table?

A
Use merged cells to group related records and leave blank rows between categories.
B
Use unique, nonblank headers, one row per record, and consistent value types in each column.
C
Put several variables in one column and use multiple rows for each record.
D
Include only the records that already have summary values.

Choose one

1 point

A pivot table uses Region in Rows and Product in Columns. What happens to the grouping if Product is moved to Rows?

A
Only fields in Rows define groups; fields in Columns are calculated values.
B
Fields in Columns filter records, while fields in Rows define groups.
C
Fields in either Rows or Columns define groups; their positions change the layout of the summary.
D
Fields in Rows and Columns alter the source records in different ways.

True or false

1 point

In a pivot table, placing a field in Rows rather than Columns changes the summary's layout, while both areas can define groups.

A
True
B
False

Choose one

1 point

You need revenue per unit for each product group. Which calculation best answers that question?

A
Calculate total revenue divided by total units for the group.
B
Calculate average revenue per transaction for the group.
C
Count the number of revenue records in the group.
D
Sum the number of transactions in the group.

Written response

1 point

A team wants the total revenue represented by each product group, not the mean or the number of records. Which value-summary operation should it use?

True or false

1 point

After adding records to a source table, a pivot table may need to be refreshed; if the new rows are outside its source range, that range may also need updating.

A
True
B
False

Fill in the blank

1 point

To compare each product's revenue as a share of all revenue, display the values as a percentage of the .

Written response

1 point

A source table has four revenue records: 120, 200, 150, and 100. What grand total would a pivot table show if Revenue is summarized by Sum?

Fill in the blank

1 point

To arrange a revenue summary with regions as row groups and product categories across the top, place Region in and Product in .

Choose all

1 point

Which practices help prepare source data for a pivot table? Select all that apply.

A
Give every column one unique, nonblank header.
B
Merge cells in a column when several records share a category.
C
Keep each column's values consistent in type.
D
Use one row per record and one column per variable.

Open ended

1 point

A manager asks, “Which product generated the most revenue in each region?” Describe how you would set up and refine a pivot table to answer the question, and explain how you would validate and keep the result current.

Choose all

1 point

Which statements correctly distinguish pivot-table filters from sorting? Select all that apply.

A
A filter rearranges groups by their summarized values; sorting excludes source records.
B
A filter narrows which records contribute to the summary.
C
Sorting can arrange groups by labels or summarized values.
D
A filter changes the source records themselves.

Choose one

1 point

Two groups have different numbers of records. What is the soundest way to find their overall average rather than simply averaging the group averages?

A
It is always correct to average group averages because every group has equal importance.
B
Use the largest group's average as the overall average.
C
Use the underlying observations or a correctly weighted calculation when group sizes differ.
D
Replace every group average with a count of its records.

Choose one

1 point

Which source-data setup is most suitable for creating a reliable pivot table?

A
Merge the header cells and leave blank rows between groups of records.
B
Use a unique, nonblank header for each column and keep records in a continuous rectangular range.
C
Put multiple variables in one column so each record uses fewer columns.
D
Mix dates and explanatory text in the same date column.

Choose one

1 point

You want a pivot table with one row per region and product categories across the top. Where should you place Region and Product?

A
Put Region in Values and Product in Filters.
B
Put Region and Product in Values, then summarize both by Count.
C
Put Region in Rows and Product in Columns.
D
Put Region in Filters and Product in Values.

Choose one

1 point

A manager wants revenue per unit for a product group. Which calculation should the manager use?

A
Divide total revenue by total units.
B
Average the revenue value in each transaction record.
C
Count the number of transactions and divide total revenue by that count.
D
Divide average revenue by the number of products.

Choose one

1 point

A sales analyst wants to find which product generated the most revenue in each region. Which pivot-table setup best answers the question?

A
Put Revenue in Rows, Region in Values, and summarize Region by Average.
B
Put Product in Filters, Revenue in Columns, and summarize Revenue by Count.
C
Put Region in Values, Product in Filters, and summarize Revenue by Average.
D
Put Region in Rows, Product in Columns, and Revenue in Values summarized by Sum.

True or false

1 point

Before interpreting a pivot table's sum, you should check whether each source row represents a distinct record for the question being answered.

A
True
B
False

Written response

1 point

A group contains three transactions with revenues of $40, $80, and $120. What is the average transaction revenue? Enter the value in dollars.

Written response

1 point

What is the name of the pivot-table field area that specifies what should be calculated for each group?