Exam 6: Analyze Data Using Tables

The function_num argument of the SUBTOTAL function can only have entries from 1 to 10 or from 101 to ________.

________ down is a method for accessing the detailed records that were used in a PivotTable to get to the aggregated data.

Raw data without context is of minimal value to users.

After a table has been converted back to data,the converted data still possesses table functionality.

When using the ________ Filter feature in Excel,filtering criteria will be listed on the same worksheet.

________ are charts that are tied to the data within a PivotTable.

It is not recommended to use the ________ formatting techniques found on the Home tab with PivotTables.

________ sets are named collections of related sets of information that are composed of separate elements.

Which of the following options is NOT listed in the Create PivotTable dialog box?

A(n)________ is an object that sits or floats on top of the spreadsheet that lists the data options of a field.

Which of the following is NOT a benefit of using PivotTables?

Pressing ________ allows you to select multiple criteria on a slicer.

It is better to use PivotTables for multiple purposes than to create a set of separate PivotTables.

It is NOT recommended to use the standard formatting techniques found on the ________ tab with PivotTables.

Standard functions can be applied to filtered data.

When filtering data,records that are on hidden rows will not automatically be used in the calculation of the ________ function.

If a set of data is not organized,it is difficult to transform the data into information.

All of the following statements are TRUE regarding PivotTables EXCEPT:

The PivotTable ________ tab focuses on formatting and the appearance aspect of designing the PivotTable.

The context-sensitive tabs available to aid in the control of the PivotTable include ________.