Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

New Perspectives on Microsoft Excel

Computing

Quiz 5 :

Working With Excel Tables, Pivot-tables, and Pivot-charts

Quiz 5 :

Working With Excel Tables, Pivot-tables, and Pivot-charts

search
arrow
Excel can summarize data in a range of data by inserting subtotals.
Free
True False
Answer:

Answer:

True

arrow
To create a custom list,in the Sort & Filter group on the  HOME \underline { \text { HOME } } tab,click the Sort button.Click the Order arrow,and then click Custom List.____________________
Free
True False
Answer:

Answer:

False
,DATA

arrow
 Custom \underline { \text { Custom } } filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.____________________
Free
True False
Answer:

Answer:

False
,Criteria

arrow
Each column represents a  record \underline { \text { record } } that describes some attribute or characteristic of a person,place,or thing.____________________
True False
Answer:
arrow
You can use a table's sizing handle to add columns or rows to a table.
True False
Answer:
arrow
You can drag one field to the FILTERS area of the PivotTable Fields pane to change what values are displayed in the PivotTable.
True False
Answer:
arrow
When you create a table,if your data does not contain column headers,Excel adds headers with default names.
True False
Answer:
arrow
If a column consists of day or month labels,you can sort them in their correct  chronological \underline { \text { chronological } } order using one of the predefined custom lists.____________________
True False
Answer:
arrow
You can create at most one Excel table in a worksheet.
True False
Answer:
arrow
If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell A1.
True False
Answer:
arrow
Before you complete a sort,you need to decide whether you want to put the list in ascending or descending order.
True False
Answer:
arrow
When you delete a record from a table,a dialog box displays to confirm the delete operation.
True False
Answer:
arrow
Table names cannot include  underscores. \underline {\text { underscores. } } .____________________
True False
Answer:
arrow
When you create a  PivotTable \underline {\text { PivotTable } } ,you need to specify where to find the data for the PivotTable.____________________
True False
Answer:
arrow
The first sort field in a sort is called the  major \underline { \text { major } } sort field.____________________
True False
Answer:
arrow
 Ascending \underline { \text { Ascending } } order arranges labels alphabetically from A to Z.____________________
True False
Answer:
arrow
img -Records have been filtered in the list shown in the accompanying figure.
True False
Answer:
arrow
The  Subtotal \underline { \text { 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 False
Answer:
arrow
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 False
Answer:
arrow
You can calculate  sort \underline { \text { sort } } statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table. ____________________
True False
Answer:
Showing 1 - 20 of 100