Exam 21: Excel: Datasets and Tables: Managing Large Volumes of Data

Conditional formatting is the process of conditioning data to make it more manageable.

Filtering:

Freezing rows and/or columns:

Which of the following is TRUE about the print area feature?

You can apply text,value,and date filters to fields based on the data in a particular field.

Tables provide advantages over regular ranges but you cannot convert a table back to a regular range of data.

When you freeze panes and press Ctrl+Home when columns A and B and row 1 are frozen,what happens?

If you have a table that extends to row 21 and you start typing in row 22,what happens?

A structured reference uses field names instead of cell references to make it easier to create formulas.

Sorting by ________ arranges data together for cells containing a particular fill or font color.

After you have created a table,you cannot add new fields to it.

In a worksheet,it is possible to ________ a manual page break to a new,desired location.

Which of the following is NOT a Table Style option?

A page break:

________ keeps rows and/or columns visible as you scroll through a worksheet.

A page ________ indicates where data starts on a new printed page.

When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.

Semiselection cannot be used to create formulas in a table.