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

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

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.

A(n)____________________ filter allows you to filter the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

You can display or hide filter arrows for an Excel table or a range of data by using the Filter button in the Sort & Filter group on the View tab.

The first sort field in a sort is called the major sort field.

PivotTable data can be a(n)____.

The item marked 2 in the accompanying figure is the ____ handle.

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

You click the item marked 3 in the accompanying figure to display rows that meet either of two criteria.

In addition to data fields a PivotTable uses ____________________ fields to groups values such as department model year and vehicle type in an automobile-related sheet for example.

In Excel a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

A PivotTable summarizes data in different categories using functions such as ____.

When you clear a filter all filters in the worksheet are cleared.

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

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

If you freeze the top row in a worksheet and press Ctrl+Home you will return to the cell directly above the frozen row.

You can filter a column of data by all of the following EXCEPT ____.

The row of field names across the top of an Excel list is referred to as the header row.