Exam 5: Exce: Working With Excel Tables Pivottables and Pivotcharts

With the Last Quarter criteria filter quarters are defined as for example ____.

The top row of a range should contain a(n)____________________ name.

The PivotTable button is available in the Tables group on the ____ tab.

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

The ____ criteria filter requires the records displayed not to have the specified text string anywhere.

Item ____ in the accompanying figure indicates the fields you want to display as the columns at the top of the PivotTable.

____ order arranges labels in reverse alphabetical order from Z to A.

To update the PivotTable click the PivotTable Tools Options tab on the Ribbon and then in the Data group click the ____ button .

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.

Item ____ in the accompanying figure indicates the fields you want to display as the rows in the PivotTable.

A(n)____________________ list indicates the sequence in which you want data ordered.

You use ____ filters to find all objects with a value greater than X or acquired after a certain date.

The process of hiding certain records and viewing the ones you want is called ____________________ your data.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons

To sort data in an Excel worksheet you can use the ____.

Press ____ to return to cell A1 in a worksheet.

Table names cannot include underscores .

A(n)____________________ is a graphical representation of the data in a PivotTable.

You can create at most one Excel table in a worksheet.

Criteria filters allow you to specify relationships other than those that are "____" the criteria specified in the filter records.