Excel Lesson 9 Knowledge Assessment

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 menu 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 menu tab.

Which is a valid reason you’d want to convert 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 from a non-Excel file.
• To prepare to change its conditional formatting.

What is the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

• None
• 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.

What 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 Items(Total Sale)
• Auction Items[#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 menu 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

What is the difference between an AutoFiltered range of records in a list and a table?

• None.
• A table maintains its sort order after you close and re-open it.    
• 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 characters may not be used to begin a field name in a table?

• = @ -
• $ = (
• % { [
• $ % @

What is the reason you would want to record a macro with absolute references rather than relative is because?

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

From which of the following does Excel not have features for importing data?

• An active database
• A Web page
• A Web search
• An XML file