How can we help?

You can also find more resources in our Help Center.

15 terms

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

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 total of 35,536 rows on a worksheet.

cell

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

cell adress

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.

sheet tabs

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

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

Function that automatically adds selected cells.

dollar symbol

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

equation

A mathematical formula typed into a cell.

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.