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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To rearrange records in a table or range based on the data in one or more fields

To delete records that are incorrect,out of date,or no longer needed,select a cell in each record you want to delete,click the Delete button arrow in the Cells group on the ____ tab,and then click Delete Table Rows.

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

If a column consists of day or month labels,you can sort them in their correct $\underline { \text { chronological } }$ order using one of the predefined custom lists.____________________

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 create a custom list,in the Sort & Filter group on the $\underline { \text { HOME } }$ tab,click the Sort button.Click the Order arrow,and then click Custom List.____________________

The second sort field in a sort is called the ____________________ field.

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

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

-To get to the screen shown in the figure above,you would click the INSERT tab on the Ribbon,and then,in the ____ group,click the PivotTable button.

When you create a $\underline {\text { PivotTable } }$ ,you need to specify where to find the data for the PivotTable.____________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To temporarily hide all the records that do not meet your criteria

Cali 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 camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number. -If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson),what should he do?

Before you complete a sort,you need to decide whether you want to put the list in ascending or descending order.

-Records have been filtered in the list shown in the accompanying figure.

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

-In the figure above,if you only want to set one criterion for this filter,you will ____.

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

You can calculate $\underline { \text { sort } }$ statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table. ____________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to group and summarize a list into a concise,tabular format