How can we help?

You can also find more resources in our Help Center.

Workbook

An Excel file with one or more worksheet

Worksheet

The work area for entering and calculation data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet.

Cell

The intersection of a column and row on a worksheet. You enter data into cells to create a worksheet.

Active Cell

The active cell contains the cell pointer. There is a dark outline around the active cell.

Formula bar

As you enter data into a cell, it simultaneously appears in the Formula bar, which is located above the worksheet.

Cell Reference

The location of a cell in a worksheet as identified by its column letter and row number. Also known as the cell's address.

Scroll

A way to view locations on the worksheet without changing the active cell.

Sheet tabs

Tabs that appear at the bottom of the workbook window, which display the name of each worksheet.

Tab scrolling buttons

Buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view.

Blank workbook

A new, empty workbook contain three worksheets.

Template

A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets.

Label

Text in the first row or column of a worksheet that identifies the type of data contained there.

Defaults

The standard settings Excel uses in its software.

Undo

The command used to reverse on or a series of editing actions.

Redo

The command used to redo an action you have undone.

AutoComplete

A feature used to complete an entry based on previous entries made in the column containing the active cell.

AutoCorrect

A feature used to automate the correction of common typing errors.

Spelling Checker

A tool used to assist you in finding and correcting typographical or spelling errors.

Value

A number entered in the worksheet.

Numeric Label

A number entered in the worksheet as a label, not as a value—such as the year 2005 used as a column label.

Label Prefix

An apostrophe (') used to indicate that a number is a label and not a value.

Series

A list of sequential numbers, dates, times, or text.

Standard Column Width

The default number of characters that display in a column based on the default font.

Formula

An instruction Excel uses to calculate a number.

Mathematical Operators

Symbols used in mathematical operations.

Order of Mathematical Operations

The order in which Excel performs the calculations specified in a formula.