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

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.

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

A field name is also called a(n)____________________.

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 can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

To calculate subtotal for a table the first step is to use the ____ button on the Table Tools Design tab.

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

When you designate a range as a(n)____ Excel provides the same operations as are available for a structured range of data.

When you delete a record from a table a dialog box displays to confirm the delete operation

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

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

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

The item marked 5 in the accompanying figure is the PivotTable ____________________ area.

One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data.

The Subtotals command offers summary information such as ____.

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

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