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

A data bar

After you select a table style, you can control what the style formats. The Table Style Options group contains check boxes to select specific format actions in a table.

An icon set

If the default conditional format options do not provide what you need, you can create your own rule for formatting.

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

Using Conditional Formatting to draw attention to cells that are blank

Conditional formatting

A page break indicates where the end of all the columns (fields) occurs.

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

________ is the process of displaying only records that meet specific conditions.

Sorting ________ from oldest to newest displays data in chronological order.

Filtering the Last_Name column (field) to show only records that begin with the letter S is an application of

To Create a new Conditional Formatting Rule, click Conditional Formatting from the Cell ________ group and select New Rule.

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

Print order

Freezing rows and / or columns

A ________ is a space for individual piece of data within a record, such as a street name.

Using Conditional Formatting to draw attention to cells containing errors

To Create a new Conditional Formatting Rule,

A print area