FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Subtotals, Pivot-tables, and Pivot-charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

A) Click Expand Field in the Active Field Group on the Analyze tab.
B) Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab.
C) Click the - button to the left of the first category.
D) You must move the second level out of the ROWS area.

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

A PivotChart has live updates as you change the PivotTable.

Correct Answer

verified

Show Answer

Question 53

True/False

Review LaterAdd Note

If you are interested in finding what products people buy when they buy coffee,you would employ data warehousing techniques on supermarket sales data.

You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?

Match each of the following terms to its description:

You cannot create custom calculations in a PivotTable.

Match each of the following Show Value as Options to its best description:

Match each of the following PivotTable summary statistic functions to its mathematical operator or explanation:

A PivotTable is limited to a single table of data.

Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable,how would you find out how many of each type of candy bar you have?

A(n)________ quickly formats a PivotTable with bold,fonts,shading,headers.

You are analyzing sales data and eating habits of students in a school cafeteria,you created a PivotTable with Date as a ROW and Extended Price as a summed VALUE.Which of the following Pivot Tables would demonstrate best what would happen if you added Category to the COLUMNS area?

________ is an add-in that enables you to relate tables and external data from multiple sources.

You created a slicer on the field State.What items would you be most likely to see in the slicer?

Filters and Slicers are the same.

A PivotTable can only display one summary statistic at a time.

What does a + button indicate to the left of a row heading in an outline?

You can clear all fields from a PivotTable.

The ________ function is the default summary statistic for PivotTables.

Where would you access the Manage Relationships dialog box to create a data model in Excel?