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

The ____ criteria filter requires the records displayed to start with the specified text string.

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 named Cathy,Carla,and Carey,what should she do?

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

The ____________________ criteria filter requires that the records displaying begin with the specified text string.

Table names cannot include $\underline {\text { underscores. } }$ .____________________

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep headings visible as you work with the data in a large worksheet

You can use a table's sizing handle to add columns or rows to a table.

What are the steps for sorting data using multiple fields?

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

When related fields are grouped together in a row,they form a(n)____________________,a collection of fields that describes a person,place,or thing.

To calculate subtotal for a table,the first step is to use the ____ button on the TABLE TOOLS DESIGN tab.

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

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

Every ____ consists of an object that contains a button for each unique value in that field.

What is a PivotTable? Describe its use in Excel,including the definition of value fields and category fields.

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

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

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.

-On the bottom-right corner of the figure above,there are four squares labeled FILTER,COLUMNS,ROWS,and VALUES.These four areas represent the ____ of the PivotTable.