Exam 14: Excel: Creating and Using Professional Forms and Reports

The Table Style Options Group

Freeze Top Row

A color scale

If the automatic page breaks occur in undesirable locations, you can adjust the page breaks.

A page break

After you apply conditional formatting, you can sort or filter a column based on its formats.

A ________ is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.

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

The Unfreeze Panes only appears on the menu when you have frozen rows and / or columns.

To ________ a table into a range, click within the table, click the Table Tools Design tab and from the Tools group, select Convert to Range.

With data arranged in a table, you can display a total row after the last record. Excel sums the values in the last column automatically

________ formatting highlights or emphasizes cells that meet certain conditions.

Previewing the worksheet in ________ view enables you to adjust print settings.

In Excel 2010, you can filter data by color just as you might filter it by text or value.

To convert a table back into a range,

Freeze Panes only locks columns above the active cell as you scroll through a worksheet.

Each row in an Excel table represents a record, which is a collection of data about one entity, such as data for one person.

A ________ row appears as the last row of a table to display summary statistics, such as a sum.

In addition to sorting and filtering cells by content you can sort and / or filter by ________ formatting.

The SUBTOTAL function