Glossary - Spreadsheet Vocabulary - Key Words

Teacher Guidelines

Examples of Spreadsheets


15 key words associated with spreadsheets

Click HERE for a spreadsheet key words revision worksheet (MSWord).

Spreadsheet: document or paper where information (data) is organized into rows and columns, usually used to work with numbers.

Row: horizontal (side by side) arrangement of cells identified by a number on the left hand side

Column: vertical (up and down) arrangement of cells identified by a letter across the top

Cell: the block formed where a column and row intersect (meet each other)

Cell address: the location of a cell on a spreadsheet. The column letter and row number of a cell (e.g. A2 or H3)

Data Entry Bar: the bar at the top of the spreadsheet used to enter data into the cell that you have chosen

Grid: a blank set-up of rows and columns in a spreadsheet for data to be entered on

Label: data entered as text, like a word or a letter

Value: data entered as numbers

Formula: a set of instructions that tells the computer to do a calculation. Formulas are equations that calculate a result from existing values or numbers, already entered into the spreadsheet.

Sum: the answer to an addition problem (=A6+A8)

Average: the sum divided by the total number of numbers to be added

Difference: the answer to a subtraction problem (=A6-A8)

Chart/graph: pictorial representation of data (bar chart, pie chart, trend graph)

What if...questions: One of the main uses of spreadsheets is to forecast or to predict!

Teacher Guidelines

Examples of Spreadsheets