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

Case 5-2 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? 

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

To add a sort field in the Sort dialog box,click the ____ button.

The ____ criteria filter requires the records displayed to have the current date.

The Subtotal command inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data.____________________

A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.

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

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

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

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

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

Each column represents a record that describes some attribute or characteristic of a person,place,or thing.____________________

Case 5-2 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. -Ted wants to be able to use his PivotTable to combine items into groups.Which of the following is true? 

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

You can drag one field to the Filters area of the PivotTable Fields pane to change what values are displayed in the PivotTable.

In addition to displaying subtotals,the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

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

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

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

When you have more than one sort field,you should use the Sort ____ to specify the sort criteria.