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

The header row must be row 1.

You can sort by ____.

Excel provides ____ predefined custom sort lists.

When you want to see all the data in a filtered table you can ____________________ or remove the filters.

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

The item marked 1 in the accompanying figure is the ____ button.

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

Item ____ in the accompanying figure indicates a field used to filter the report by selecting one or more items enabling you to display a subset of data in a PivotTable report.

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

Using Excel you can ____.

In the accompanying figure Installation Sculpture and Textile are all part of the list of ____ options.

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

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

You can change the values within the PivotTable because the PivotTable is linked to the source data.

The item marked 1 in the accompanying figure is the ____ for the first condition.

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

You click the item marked 4 in the accompanying figure to display rows that meet both criteria.

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.