Excel Data and Macros Quiz

Which of the following procedures is not a way to sort a table by the contents of one column?

• Click an AutoFilter button in the field names row.

• Click the Sort button in the Sort & Filter group of the Data tab.

• Click the AutoFilter button in the total row at the bottom.

• Click an AutoFilter button in the total row.

Which of the following are valid reasons for converting a table to a range?

• To clear the sorting criteria and start over.

• To prepare to change its conditional formatting.

• To prepare for deleting a column.

• To prepare for importing new data from a non-Excel file.

Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

• Only an Auto Outlined worksheet may contain total rows.

• There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.

• Only a multi-grouped worksheet can cluster rows and columns.

• An Auto Outlined worksheet contains only one button for collapsing and expanding.

Which of the following is a correct reference to cells in the Total Sale column on the rightmost side of a table called Auction Items?

• Auction Items(Total Sale)

• Auction Items[#Totals]

• Table[Auction Items(Total Sale)]

• #Totals[Total Sale]

Which of the following procedures is not a way to filter a table by the contents of one column?

• Click the AutoFilter button in the total row at the bottom.

• Click the Filter button in the Sort & Filter group of the Data tab.

• Right-click the cell whose contents you want for the criterion and click Filter in the menu.

• Click the criterion button on the slicer.

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?

• A table enables special subtotal functions for total rows.

• A table given a title enables its field names to be used in formulas in place of cell references.

• A table maintains its sort order after you close and then open it again.

• There is no difference between an AutoFiltered range of records in a list and a table.

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 the results of any formulas produced by the macro to be accurate.

• You want the values of any cells copied to the macro to be accurate.

• You want the macro to reproduce its results in the same place each time.

• You want to preserve the integrity of any cells referenced by formulas in the macro.

Which of the following does Excel not provide features for importing data?

• A Web search

• A Web page

• An active database

• An XML file