How can we help?

You can also find more resources in our Help Center.

Workbook

An excel document which contains three worksheets by default but can have more than three

Worksheet

A single sheet contained in an excel workbook

Sheet Tabs

Labels located at the bottom of the workbook window indicating the worksheets.

Column

In a spreadsheet, these are the vertical spaces. Columns are headed with letters. There are a total of 256 columns on one worksheet.

Row

In a spreadsheet the row is the horizontal group of cells. Rows are named with numbers, i.e. 1,2,3. There are a total of 35,536 rows on a worksheet.

Cell

This is the place where information is held in a spreadsheet.

Cell Address

named using the letter and number where the column and row intersect

Active cell

This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected.

name box

Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.

autosum

a function that automatically adds the values in the cells directly above or to the left of the active cell

dollar symbol

Function that changes the contents of a cell to currency, adding a dollar sign and decimal places

equation

a mathematical statement that two expressions are equal

entry bar

The toolbar on the Microsoft Excel window that shows the text or formulas.

percent

A function that allows the user to change the value of a cell to a percent

sort

In a database this function puts the records into a specific order.