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

The ____ option buttons in the Custom AutoFilter dialog box are used if you want to display rows and columns that meet two conditions for the field.

Excel can summarize data in a range of data by inserting subtotals.

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

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 fields you use to order your data are called sort ____.

You can use a table's sizing handle to add columns or rows to a table.

The fields you use to order the data in a list are sort fields.

You click a filter arrow to open the Filter menu for a field.

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

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box and checking the ____ check box.

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

To show items hidden in a PivotTable you click the field arrow button and check the check box for the item you want to show.

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

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

The ____ list box in the Custom AutoFilter dialog box lets you specify the field value by typing a value or selecting an item from a list.

In laying out the PivotTable on the worksheet you can click and drag the fields you want to appear as columns at the top of the PivotTable into the ____ layout area.

You can use up to ____ sort fields in a single sort.