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

As you type in a cell ____ displays any existing entry in the column that matches the characters you typed.

In Excel a collection of similar data can be structured in a(n)____ of rows and columns.

By default the PivotTable report uses the ____ function for numbers in the Values area.

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

Which of the following is NOT a valid table name?

After data is filtered you can do all of the following EXCEPT ____ it.

In PivotTable terminology the fields that you summarize are known as ____________________ fields.

Typically you want to sort by the numbers text or dates stored in the cells which are all ____________________.

Records have been filtered in the list shown in the accompanying figure.

A table can include all of the following EXCEPT ____

Item ____ in the accompanying figure indicates the fields you want to summarize.

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

The Summary command automatically inserts a subtotal line into the list for each group of data in the list.

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

If a column consists of day or month labels you can sort them in their correct chronological order using one of the predefined custom lists.

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

When the Subtotals feature "outlines" your worksheet by default the highest level is active.