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

Each column of a table represents a "Stack" which holds multiple pieces of data, such as first / last name and address of a single customer.

In Excel 2010, you can create formatting rules based on formulas to set conditions based on content in multiple columns.

To Freeze Columns and / or rows

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

You can sort data by one or more columns.

The Table Style Options Group

To create a table from an existing range of data,

Filtering

Previewing the worksheet in Backstage view

Top Bottom Rules

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

The Table Style ________ group contains check boxes to select format actions.

A ________ area defines the range of data to print.

Plan the fields for a table carefully because after creating, you cannot add new fields.

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

Filtering is the process of deleting records that meet specific conditions.

Sorting arranges records in a table

Each column in a table

Each row in an Excel table

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