Exam 6: Analyze Data Using Tables

To edit or view existing named ranges,click the Define Name button on the Formulas tab.

The PivotTable ________ tab has all the options for fine-tuning the PivotTable.

While it is possible to create multiple PivotTables from the same data set,only ________ PivotTable(s)is/are allowed per worksheet.

________ is data that has context,meaning,and relevance.

When PivotTable data are rearranged,corresponding changes are automatically made in the PivotChart.

Gender and dates are two examples of PivotTable ________ variables.

A ________ is a visual mechanism for quickly filtering data in a PivotTable.

A table can be created by selecting a range on an Excel worksheet,clicking the ________ tab,clicking the Format as Table button,and selecting a table style.

All of the following statements are TRUE regarding slicers EXCEPT:

Which of the following functions is NOT available as an option when selecting the SUBTOTAL function's first argument?

If there are a lot of groups within a field,it is better to put those fields across the top in the columns of a PivotTable instead of along the row side.

Use the ________ button on the Options tab to update PivotTable data changes made to source data.

________ allows a user to import up to one million rows of data from multiple sources,such as large corporate databases,public data feeds,spreadsheets,and text files on your computer.

As columns or rows are added to a table formatted with a banded style,the new columns and rows are automatically formatted to match the banded style.

Summarize Values By located on the ________ tab offers a list of alternatives for summarizing data values.

Multiple data sets that need to be filtered should be placed on separate worksheets.

________ allows a user to select an individual piece of data in a PivotTable and then create a copy of individual records that were used to get that summary data on another worksheet.

Using Excel's Hide Rows feature is a recommended feature when filtering data.

A table defaults to a table style that has ________ rows,making it easier to read data across rows.