Excel

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion. ____________________

You can drag one field to the Filters area of the PivotTable Fields pane to change what values are displayed in the PivotTable.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

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

You can create at most one Excel table in a worksheet.

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

If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.

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. ____________________

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

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

When you create a PivotTable, you need to specify where to find the data for the PivotTable. ____________________

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

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

To create a custom list, in the Sort & Filter group on the Home tab, click the Sort button. Click the Order arrow, and then click Custom List. ____________________

You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table. ____________________

The Subtotal command inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data. ____________________

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

Ascending order arranges labels alphabetically from A to Z. ____________________

Table names cannot include underscores. ____________________

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