Workbook Quiz - Module 7

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

• an existing PivotTable

• another PivotChart

• a column or bar chart on another worksheet

• a slicer on the same worksheet

Which of the following groups and summarizes data in a concise format of rows and columns?

• Area chart

• PivotTable

• Slicer

• Filter

Jin wants to insert a recommended PivotTable. After clicking a cell in a data range, what should he select?

• PivotTable button on the Charts tab

• PivotTable button on the Insert tab

• Recommended PivotTables button on the Insert tab

• Recent PivotTables button on the Insert tab

To which of the following locations can you move a PivotChart?

• New workbook

• Worksheet in the current workbook

• Worksheet in a different workbook

• You cannot move a PivotChart

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

• Compact Form

• Outline Form

• Tabular Form

• Chart Form

Which of the following is the default name assigned to the first PivotTable in a workbook?

• Table1

• New PivotTable

• PivotTable1

• Pivot1

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

• True

• False

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

• SUM

• COUNT

• MIN

• VAR

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

• True

• False

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.

• True

• False