01
Choose one
1 point
A sales table has Region, Product, and Sales fields. Which pivot table layout summarizes total sales for each region–product combination?
Free Practice Quiz Question List
5 Pivot Tables Online Quiz Questions
Use this free practice quiz with 20 questions to review 5 Pivot Tables, test your knowledge, and prepare for your next test or exam.
20 questions
02
Choose one
1 point
A pivot table counts Sales entries when you expected a total. Which source-data problem is a likely cause?
- A
The Sales field must always be summarized using Average.
- B
The Sales values may be stored as text rather than as numbers.
- C
The Region field must be removed from Rows before Sales can be summed.
- D
The pivot table has automatically deleted some of the source transactions.
03
Choose one
1 point
You add transactions to the source data, but the pivot table still shows the previous results. What should you do if the table does not update automatically?
- A
Move the changed records into the Columns area.
- B
Remove all filters and recreate the source table.
- C
Refresh or update the pivot table if it does not update automatically.
- D
Change every Values field to Count.
04
Choose one
1 point
A report with individual transaction dates is too long, and you want to compare results month by month. What pivot table change best fits this goal?
- A
Group the transaction dates by month.
- B
Move Sales from Values to Filters.
- C
Replace each date with a manually entered monthly total in the source data.
- D
Remove Date from the source table.
05
Choose one
1 point
You want a report-level control that lets a viewer include or exclude records by Year. Where should you place the Year field?
- A
Put the field in Values and summarize it using Average.
- B
Put the field below another field in Rows to create nested detail.
- C
Put the field in Columns so its categories appear across the top.
- D
Put the field in Filters to provide a report-level control.
06
Choose all
1 point
You are checking a source range before creating a pivot table. Select all practices that support a reliable source table.
- A
Give each column a distinct header.
- B
Keep one record in each row.
- C
Store one kind of information in each column.
- D
Merge cells across multiple records to make related entries easier to read.
07
Choose all
1 point
You want to investigate how monthly sales differ by region for a particular period. Select all layout choices that directly support this analysis.
- A
Group Date by month.
- B
Place Region in Rows.
- C
Place Sales in Values and summarize it by Sum.
- D
Filter to the period of interest.
08
True or false
1 point
True or false: Removing a field from a pivot table layout deletes that field and its data from the source table.
- A
True
- B
False
09
True or false
1 point
True or false: A total shown in a filtered pivot table necessarily describes every record in the source dataset.
- A
True
- B
False
10
Written response
1 point
Which pivot table summary calculation shows the smallest value in a numeric field?
11
Written response
1 point
A pivot table lists regions in Rows. Which field should you add below Region in Rows to show transaction dates nested under each region?
12
Fill in the blank
1 point
To help the pivot table recognize each field correctly, store dates as and sales amounts as .
13
Fill in the blank
1 point
In a pivot table, grouping combines detailed items into broader .
14
Open ended
1 point
A report listing every individual age is too long to interpret. Describe how you could summarize ages in broader groups and what you should check to avoid leaving records out unintentionally.
15
Choose one
1 point
A sales table contains Region, Product, and Sales fields. Which layout summarizes sales for each region–product combination?
- A
Put Region in Values, Product in Rows, and Sales in Columns.
- B
Put Region in Rows, Product in Columns, and Sales in Values.
- C
Put Sales in Rows, Region in Columns, and Product in Filters.
- D
Put Product in Filters, Region in Values, and Sales in Rows.
16
Choose one
1 point
You want to rank regions according to their summarized sales. Which statement describes a supported way to sort pivot-table categories?
- A
Pivot-table categories can only be sorted by their names.
- B
Sorting categories by summarized values changes the original records.
- C
Pivot-table categories can be sorted by summarized values.
- D
Categories can only be sorted after their fields are removed.
17
Choose one
1 point
A source table uses “West,” “west,” and “W.” for the same region. Before building a pivot table, what should you do?
- A
Keep all spellings because the pivot table automatically recognizes them as the same region.
- B
Standardize the region labels so the same region is entered consistently.
- C
Merge cells containing region names to group the records.
- D
Add blank rows between different region names.
18
True or false
1 point
True or false: Filtering a pivot table to show only selected regions deletes the other regions’ records from the source data.
- A
True
- B
False
19
Written response
1 point
What kind of entries does the Count summary count? Enter the exact two-word phrase.
20
Written response
1 point
Rearranging fields changes the pivot-table report’s ______, not the original records. Enter the noun used in the material.