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

To add a record (row) to a table,

Each ________ in an Excel table represents a record.

To Freeze Columns and / or rows use the View Tab, Window Group, and then click ________ Panes.

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

In Excel 2010, Dataset

Sorting Dates oldest to newest

To remove duplicate records (rows),

A ________ reference is a tag or use of a table element as a reference in a formula.

Once you set custom page breaks, Excel 2010 freezes the panes so users cannot change the breaks on the current sheet.

A ________ bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.

To create a ________ from an existing range of data, click the Insert tab and then click Table in the Tables group.

Filtering the Date column (field)to show only records older than January 2001 is an application of

A table

________ arranges records in a table by the value in field(s) within a table.

Filtering the Last_Name field to show only records that begin with the letter S is an application of a ________ Filter.

Using Conditional ________ to highlight errors" helps locate errors in cells quickly.

Filtering the Cost column (field) to show only records Greater than $10,000 is an application of

A field

Using Conditional Formatting to highlight ________ is useful to see where you are missing data.

A structured reference