# Excel

## Unlock all answers in this set

question
Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion. ____________________
FALSE
question
You can drag one field to the Filters area of the PivotTable Fields pane to change what values are displayed in the PivotTable.
FALSE
question
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.
TRUE
question
Excel can summarize data in a range of data by inserting subtotals.
TRUE
question
You can create at most one Excel table in a worksheet.
FALSE
question
When you delete a record from a table, a dialog box displays to confirm the delete operation.
False
question
If you freeze the top row in a worksheet and press Ctrl+Home, you will return to the cell A1.
True
question
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. ____________________
True
question
You can use a table's sizing handle to add columns or rows to a table.
True
question
True
question
When you create a PivotTable, you need to specify where to find the data for the PivotTable. ____________________
True
question
The first sort field in a sort is called the major sort field. ____________________
False
question
In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.
range
question
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. ____________________
FALSE
question
You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table. ____________________
False
question
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. ____________________
True
question
Before you complete a sort, you need to decide whether you want to put the list in ascending or descending order.