Excel Terminology

Front

Table

Back

A group of cells that have been formatted in a column or row tabular format.

Front

Range of cells

Back

A group of consecutive or non-consecutive cells in a worksheet that have been selected. Also known as a cell range.

Front

Sort

Back

A command that sorts the contents of a range or table. You can sort data values by one or more columns, and the command returns only the matching results.

Front

Filter

Back

A command that filters a range or table based on selected criteria. Only matching criteria results are displayed.

Front

Style

Back

A combination of pre-formatted attributes that can be applied to a range of cells or a table.

Front

Outlier

Back

A value outside the quartile range within a box-and-whisker chart.

Front

Quartile

Back

A calculation used in a box-and-whisker chart. More detail is provided in Lesson 4, Topic 2, plus a link to Microsoft Office support.

Front

Stacked

Back

An option available within various chart types.

Front

Summary Report

Back

A report created automatically on a separate worksheet by using the Scenario Manager.

Front

Syntax

Back

The order of a formula.