9

Which custom sort order (custom lists is built into Excel?

Select an answer:

• U.S. regions

• names of seasons

• three-letter abbreviations of month names

• U.S. state names

10

Your Pivot Table has the products you purchase in Column A, andSum of Total Purchases in Column B. Which mistake do users oftenmake when creating filters?

Select an answer:

• filtering in Sum of Total Purchases

• filtering by Begins With

• filtering by the values associated with the products

• filtering by using Value Filters

11

Which function do "slicers" have in an Excel Pivot Table?

Select an answer:

• Slicers are the way multiple fields are filtered through.

• Slicers are limitations on filtering data in a Pivot Table.

• Slicers are a deeper level filter applied to a filter.

• Slicers are a visual display of filters applied to a PivotTable.

12

When using a slicer to filter a PivotTable, which key would youhold down so you can select multiple items within the slicer?

Select an answer:

• Ctrl

• Alt

• Tab

• Esc

13

Your Pivot Table shows purchases for each quarter of 2019 forthree products you buy. If you perform the operation in the Analyzeto Show Report Filter Pages by category, what will you create?

Select an answer:

• three Pivot Tables, one for each product category, on the sameworksheet

• three separate worksheets, one for each product category

• four separate worksheets, one for each quarter

• four Pivot Tables, one for each quarter, on the sameworksheet

14

Which control lets you visually define a filter based on a daterange?

Select an answer:

• Treemap

• Slicer

• Calendar

• Timeline

15

When you are creating relationships between tables, the uniquevalues for each row are known as the _____.

Select an answer:

• index

• foreign key

• data model

• related table

16

Which function is used to refer to a cell in a PivotTable?

Select an answer:

• PIVOTDATA

• GETPIVOTDATA

• GETPIVOT

• GETDATA

17

When you create a formula by using = then clicking on a valuecell in a Pivot Table, which action are you taking?

Select an answer:

• You are using a shortcut instead of typing out the cellreferences by column and row numbers.

• You are using the underlying data in the formula you aredefining.

• You are using the value shown in the cell in the formula you aredefining.

• You are using the range of cells in the Pivot Table in theformula you are defining.