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

Excel provides ____ predefined custom sort lists.

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

A data ____ table describes the fields you plan to maintain in a table.

The ____ report layout displays one column for each field and leaves space for column headers.

When you click in each cell in the ____ row,an arrow appears that you can click to open a list of the most commonly used functions.

You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names.

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

You can point to any style in a gallery to see a ____ of the PivotTable with that style applied.

When you create a table,if your data does not contain column headers,Excel adds headers with default names.

You can split the worksheet window into ____ separate panes.

To rearrange records in a list,you sort based on the data in one or more of the fields.

The ____ filtering option displays the top or bottom 10 (or specified number)items in a list.

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

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

The Subtotals command offers summary information such as ____.

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

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person,place,or thing.

After Excel displays an existing entry in the column that matches the characters you typed,press the ____ key to accept the entry.

-Referring to the figure above,in row 117,in the last full column shown,there is a small triangle shown in the bottom-right corner of the cell.This triangle indicates ____.