Glossary of Terms

Absolute reference
A reference to a specific cell.
Alignment
The way in which the contents of a cell are arranged as flush left, centre or flush right.
Ascending sort
The sorting of a list with the lowest value or lowest alphanumeric character first.
Axis label
The text to describe the type of data represented by the axis of a graph or chart.
Box
Synonymous with cell.
Cell
A unit on a spreadsheet matrix into which can be input via the keyboard, numbers or formulae. Each cell is located by reference to its column and row.
Cell border
The boundary of a cell or range which may be highlighted with an outline box.
Cell name
A name given to a cell which can be used in formulae or to locate the cell.
Cell reference
The unique description of a cell.
Clear
The action of deleting the contents of a cell or range of cells.
Column
The vertical strips of cells which run down the length of a spreadsheet which are sometimes labelled with letters.
Column header
The unique identifier of a column.
Command line
The line on the screen in non-graphics user interface spreadsheet packages which displays the commands when in command mode.
Copy
To copy the contents of a cell or range of cells into others to avoid repetitive typing. When copying cell references they are automatically altered to keep in step with the appropriate row or column unless the cell contains an absolute reference.
Cut
To delete the contents of a cell or cells and store them in a temporary memory buffer. The contents can be returned to a chosen location of the spreadsheet matrix with the paste command.
Data label
This shows the spreadsheet value from which a category in a pie chart, for example, is calculated.
Descending sort
The sorting of a list with the highest value or highest alphanumeric character first.
Embedded graph
A graphical display which can be stored and manipulated on the screen within the spreadsheet matrix.
File
A collection of related records.
Fill down
To copy the contents of a cell or row range down a column or columns. When copying cell references they are automatically altered to keep in step with the appropriate row or column unless the cell contains an absolute reference.
Fill right
To copy the contents of a cell or column range across a row or rows. When copying cell references they are automatically altered to keep in step with the appropriate row or column unless the cell contains an absolute reference.
Fill series
To replicate a number, date or formula in a row or column that automatically increases or decreases by specified increments.
Footer
A design element that is repeated at the bottom of each page.
Formula
A calculation which may include functions, operations or references to other cells.
Font or Fount
A set of characters available in the same typeface, style, size and stroke weight. Although the US spelling, font, is common in documentation, the British spelling is used in this site.
Freeze titles
To lock the top row or rows and or the left most column or columns so that they remain fixed in position on the screen or page as the rest of the screen display is scrolled.
Function
An entity which returns a value. The entity is a key word to denote the function followed by parentheses. Within the parentheses is the argument, often a range of cells, on which the function is to be performed. Some functions do not need arguments but retain the parentheses.
Gridline
Some spreadsheet applications allow you to display or print the lines which mark out the cells of the matrix.
Header
A piece of text which is repeated at the top of every page.
Label
The descriptive word or words used to describe the contents of ranges of cells.
Legend
A key on a graph or chart to tell you what the patterns, colours or markers mean that fill areas of the display.
Live graph
A graphic display which retains the links with the data from which it is derived so that if the data is changed the graph is automatically changed too.
Load
The action of bringing a program or data file into the computer's main memory.
Lock/unlock
To lock the top row or rows and or the left most column or columns so that they remain fixed in position on the screen or page as the rest of the screen display is scrolled. Can also refer to locking cells to prevent alteration of their contents.
Lookup
A function which looks up an entry in a reference table and returns either a matching entry or an error code.
Macro
A tiny program to automate a task. Macros used to be simply a stored sequence of keystrokes. However, they may now be written in a procedural programming language.
Margins
The margins set round the edge of a page, top, bottom, left, right. Within the top margin a header margin can be set and within the bottom margin a footer margin can be set.
Number format
The way in which a number is displayed in a cell. There are a number of common formats such as fixed, currency, comma, percent, leading zeros, true/false, time/date.
Operating system
The program that manages and controls all the main actions of the computer, providing standard interfaces for other programs, hardware and users.
Operator
These perform all the basic actions on numbers or characters. There are three basic groups, mathematical (eg +), relational (eg =) and logical (eg AND).
Page
A division of whole of the display which will fit onto the print paper size specified for the file.
Page layout
The layout of the page with regard to features such as margins, headers, footers, page length, page width and page number.
Paste
Pasting the contents from a copy or cut action onto the screen at a specified location.
Print preview
This allows you to look at the pages of your spreadsheet as they will appear when they are printed out.
Range
An area of the spreadsheet made up of one or more rows and or one or more columns.
Range name
The name given to a range which can be used in formulae or to locate the range.
Relative reference
A reference to a cell which is relative to the current cell's position.
Replicate
To repeat or copy the same formula in other cells without altering cell references.
Row
The horizontal strips of cells which run across the width of a spreadsheet which are usually labelled with numbers.
Row header
The unique label of a row, usually a number.
Run
A command that causes a program to be executed.
Scrolling
The action of moving around to view the portions of a spreadsheet when only a part of the spreadsheet is visible on the screen at any one time because of its size.
Sort
A utility which allows rows or columns to be put into alphabetical or numerical order.
Spreadsheet
A computer program which processes text, numbers and formulae stored in a matrix of rows and columns.
Text format
The appearance of text in relation to fount (eg. Times New Roman), fount size (eg. 12 point), fount style (eg. bold) or fount position (eg. subscript).
Tool bar
A bar across the top of a screen display with icon buttons to activate spreadsheet commands using the mouse cursor.
Window
Split screens whereby different files can be viewed at the same time. One window is active at a time.

Contents: Spreadsheets

Skill Check: Spreadsheets