Exam 5: Working With Excel Tables, Pivot-tables, and Pivot-charts

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

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

To create a custom list,in the Sort & Filter group on the Home tab,click the Sort button.Click the Order arrow,and then click Custom List._________________________

The fields you use to order your data are called sort ____.

You click a filter arrow to open the AutoFilter menu for a field.

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

As you type in a cell,____ displays any existing entry in the column that matches the characters you typed.

-On the far right,in the figure above,there is the PivotTable field list.The items listed there,such as "Artist" and "Title" are ____ in the ArtObjects table.

The worksheet you are viewing is "Sheet1." To set the PivotTable in its own sheet all of the following are true EXCEPT:

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists.

When you click in each cell in the Total row,a(n)____ appears that you can click to open a list of the most commonly used functions.

Excel assigns the name ____ to the first Excel table created in a workbook.

In PivotTable terminology,the fields that you summarize are known as ____________________ fields.

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

Case-Based Critical Thinking Questions Case 5-2 Simon has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a staff directory table that includes First Name,Last Name,Office Number,Department Name,and Phone Number. -If Simon wants to find all of his colleagues named Joseph,Joanne,and Josephine,what should he do?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of related fields that are grouped together

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

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

When you want to see all the data in a filtered table,you can ____________________,or remove,the filters.

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