1. Which
Ribbon has the command for creating Pivot Tables?
a. Home
b. Insert
c. Data
d. Review
Tip: Advanced Excel, page 87
2. Which are the Table Tools Ribbons?
(Select all
correct answers.)
a. Options
b. Design
c. View
d. Format
Tip: Advanced Excel, page 89
3. Where do the Pivot Table fields come from?
a. Entered in the Pivot Table dialogue box
b. The spreadsheet labels
c. Default in Excel
Tip: Advanced Excel, page 90
4. The row
labels in a Pivot Table are filters.
a. True
b. False
Tip: Advanced Excel, page 93
5. Which of the following are functions a Pivot Table can use?
(Select all
correct answers.)
a. Count Numbers
b. Sum
c. Average
d. Max
e. Min
f. Product
Tip: Advanced Excel, page 97
6. Which of the following are true about subtotals in Pivot Tables?
(Select all
correct answers.)
a. Default is to show the subtotal at the top of the group
b. Command is Pivot Tables-> Tools-> Design> Layout-> Subtotals
c. Subtotals cannot be removed
Tip: Advanced Excel, page 104
7. Which of
the following is an option for Grand Totals? (Select all correct
answers.)
a. Added to Rows
b. Added to Columns
c. Added to both Rows and Columns
d. Added to neither Rows or Columns
Tip: Advanced Excel, page 106
8. Which of the following are report options?
(Select all
correct answers.)
a. Show in Compact form
b. Show in Outline form
c. Show in Tabular form
Tip: Advanced Excel, page 110
9. A Pivot Table can be formatted with Styles
a. True
b. False
Tip: Advanced Excel, page 111
