Review 25/04

Edwin wants to insert a PivotChart to summarize sales data. On which of the following does he need to base the new PivotChart?

• an existing PivotTable

• another PivotChart

• a column or bar chart on another worksheet

• a slicer on the same worksheet

A(n) _____ groups and summarizes data in a concise format of rows and columns.

• Area chart

• PivotTable

• Slicer

• Filter

Which of the following is the default function Excel uses to summarize non-numeric data in a PivotTable?

• SUM

• COUNT

• MIN

• VAR

Which of these is the default layout for a newly created Pivot table?

• Compact Form

• Outline Form

• Tabular Form

• Chart Form 

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?

• =IF(B2>=70, C2>=80)

• =OR(B2>=70, C2>=80)

• =AND(B2>=70, C2>=80)

• =NOT(OR(B2>=70, C2>=80))

How can you drill down a PivotTable to display detailed data?

• Double-click a cell in the PivotTable.

• Right-click a cell in the PivotTable, and then click Details.

• Add a field to the Drill area of the PivotTable.

• Click the minus button next to a field in the PivotTable.

Which of the following functions would you use to find the column location of specified text?

• MATCH

• INDEX

• VLOOKUP

• HLOOKUP

What must you do to have a filter button appear in the upper-left corner of a PivotTable?

• Add a field to the Filters area.

• Add a field to the Rows area.

• Remove any slicers.

• Show the field buttons for the PivotTable.

If a PivotTable field is expanded, you can click the minus button to collapse the field and hide field details.

• True

• False

The PivotTable Fields pane lists the fields available to the PivotTable.

• True

• False