Question 1 (1 point)
Xan wants to change the number format in a PivotTable and its PivotChart. To do so, she can use the Number Format button in the Value Field Settings dialog box.
 a
True
 b
False
Question 2 (1 point)
The PivotTable Fields pane lists the fields available to the PivotTable.
 a
True
 b
False
Question 3 (1 point)
Roberta added a calculated field to the Values area of a PivotTable, where it appears as "Sum of ORDERS." Where can she change the text displayed for this field?
 a
Number Format dialog box
 b
Calculated Field Format dialog box
 c
Value Field Settings dialog box
 d
PivotTable Options dialog box
Question 4 (1 point)
When you add fields to the Columns area of a PivotTable, they appear as headings at the top of the table.
 a
True
 b
False
Question 5 (1 point)
A(n) _____ groups and summarizes data in a concise format of rows and columns.
 a
Area chart
 b
PivotTable
 c
Slicer
 d
Filter
Question 6 (1 point)
You can hide the PivotTable Field pane by deselecting the Field List button on the PivotTable Tools Analyze tab. 6/24/2020
 a
True
 b
False
Question 7 (1 point)
To hide the PivotTable Fields pane, deselect the Field List button on the PivotTable Tools Analyze tab.
 a
True
 b
False
Question 8 (1 point)
Add a numeric field to the Values area to sum values for each intersection of a row category and column category.
 a
True
 b
False
Question 9 (1 point)
Which of the following is the default function Excel uses to summarize non-numeric data in a PivotTable?
 a
SUM
 b
COUNT
 c
MIN
 d
VAR
Question 10 (1 point)
How can you drill down a PivotTable to display detailed data?
 a
Double-click a cell in the PivotTable.
 b
Right-click a cell in the PivotTable, and then click Details.
 c
Add a field to the Drill area of the PivotTable.
 d
Click the minus button next to a field in the PivotTable.
Question 11 (1 point)
Edwin wants to insert a PivotChart to summarize sales data. On which of the following does he need to base the new PivotChart?
 a
an existing PivotTable
 b
another PivotChart
 c
a column or bar chart on another worksheet
 d
a slicer on the same worksheet
Question 12 (1 point)
Where does Excel list the fields available for a PivotTable?
 a
in the PivotTable itself
 b
in the PivotTable Fields pane
 c
on the PivotTable Tools Analyze tab
 d
in the PivotTable Styles gallery
Question 13 (1 point)
To create a PivotTable layout, you can drag fields from the field list to an area box in the PivotTable Fields pane.
 a
True
 b
False
Question 14 (1 point)
If a PivotTable field is expanded, you can click the minus button to collapse the field and hide field details.
 a
True
 b
False
Question 15 (1 point)
Which of the following functions would you use to find the column location of specified text?
 a
MATCH
 b
INDEX
 c
VLOOKUP
 d
HLOOKUP
Question 16 (1 point)
You should not move a PivotChart because it must be on the same worksheet as its PivotTable.
 a
True
 b
False
Question 17 (1 point)
The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?
 a
=IF(B2>=70, C2>=80)
 b
=OR(B2>=70, C2>=80)
 c
=AND(B2>=70, C2>=80)
 d
=NOT(OR(B2>=70, C2>=80))
Question 18 (1 point)
If a worksheet arranges lookup values in rows rather than columns, which function is best for retrieving data from the lookup table?
 a
VLOOKUP
 b
HLOOKUP
 c
INDEX
 d
MATCH
Question 19 (1 point)
The scores of a student in two subjects are inserted in cells B2 and C2. The passing score for each subject is 60. Which of the following formulas returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?
 a
=IF(B2>=60, C2>=60)
 b
=OR(B2>=60, C2>=60)
 c
=AND(B2>=60, C2>=60)
 d
=NOT(OR(B2>=60, C2>=60))
Question 20 (1 point)
If you add two fields to the Rows area of a PivotTable, you can click the plus box to expand the fields and display their values.
 a
True
 b
False