NEW
Font size
WorksheetsMOAC Excel 2016 Lesson 09
Total questions: 10
Worksheet time: 5mins
Which of the following procedures is not a way to sort a table by the contents of one column?
Click the Sort button in the Sort & Filter group of the Data tab.
Click an AutoFilter button in the total row.
Click an AutoFilter button in the field names row.
Click the Filter button in the Sort & Filter group of the Data tab.
Which of the following are valid reasons for converting a table to a range?
To clear the sorting criteria and start over.
To prepare for deleting a column.
To prepare for importing new data form a non-Excel file.
to prepare to change its conditional formatting.
Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?
There is no difference between an Auto Outlined worksheet and a worksheet and a worksheet with multiple groups.
Only an Auto Outlined worksheet may contain total rows.
An Auto Outlined worksheet contains only one button for collapsing and expanding.
Only a multi-grouped worksheet can cluster rows and columns.
Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?
Table[Auction Items(Total Sale)]
Auction Item (Total Sale)
Auction Item [#Totals]
#Totals[Total Sale]
Which of the following procedures is not a way to filter a table by the contents of one column?
Click the criterion button on the slicer.
Right-click the cell whose contents you want for the criterion and click Filter in the menu.
Click the Filter button in the Sort & Filter group of the Data tab.
Click the AutoFilter button in the total row at the bottom
Which of the following attributes is not a potential criterion for an AutoFilter sort?
Font color
Font style
Cell color
Cell icon
Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?
There is no difference between an AutoFiltered range of records in a list and a table.
A table maintains its sort order after you close and then open it again.
A table given a title enables its field names to be used in formulas in place of cell references.
A table enables special subtotal functions for total rows.
Which of the following characters would not appear on an outline symbol or control for grouped or outlined data?
+
@
2
-
Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative?
You want to preserve the integrity of any cells referenced by formulas in the macro.
You want the values of any cells copied to the macro to be accurate.
You want the results of any formulas produced by the macro to be accurate.
You want the macro to reproduce its results in the same place each time
Which of the following does Excel not provide features for importing data?
An active database
A Web page
A Web search
An XML file
