Microsoft Excel Terminology

26 terms by duhonlauren

Create a new folder

Advertisement Upgrade to remove ads

BCA

Spreadsheet

A type of software for evaluating information

Workbook

The name of a document in Excel

Sheet

A page in an Excel workbook

Cell/active cell

A cell is the rectangular area where a row and column intersect

Formula Bar

Found directly above column headings; shows location in spreadsheet and what was typed in cell

Sheet tab

Tabs you use to select different sheets

Values

Numbers that represent a quantity

Formulas

An arithmetical expression used to calculate values

Functions

A prewritten formula that provides a shortcut to common calculations

Range

A single cell or any rectangular block of cells

Input

Data that is to be entered into a worksheet

Output

The information the worksheet is designed to generate

Order of precedence

The rules for determining how to perform calculations containing multiple arithmetical operators

Relative cell reference

Cell reference which changes according to the location of the cell in which the reference occurs

Absolute cell reference

Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location

Argument

The specific values on which the function is to operate

AutoFormat

A feature that allows you to change a worksheet's overall appearance by choosing from predefined formats

Border

Lines used to distinguish different zones on a worksheet

Chart

A graphic representation of data

Plot area

The area defined by the X and Y axes of a chart

Data point

A single value originating in a worksheet

Data marker

A graphic representing a single value (bar, slice, etc.)

Data series

A group of related data points

Embedded chart

A chart which is positioned as part of an existing worksheet

Chart sheet

A special worksheet which contains a single chart only

Nonadjacent range

A group of individual cells or ranges of cells that are not next to each other

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set