Home > Business Services > Business Services (120/240 hours) > Create and use simple spreadsheets > Create and use simple spreadsheets
| Term | Definition |
|---|---|
|
Absolute and relative cell addresses
|
Absolute cell addresses – references to a particular cell or groups of cells that refer to a specific location or locations. Relative cell addresses – references to a cell or group of cells that changes depending on the location. |
|
Axis title |
Text that explains what data a chart axis represents. |
|
Cells |
The intersection of columns and rows, boxes in which can a single piece of data can be entered |
|
Data range |
A group of cells containing data |
|
Division |
A function that determines how many times one quantity is contained in another |
|
Efficiency of formulae |
Effectiveness of formulae to produce the required result using the least number of steps |
|
Formatting |
Specifying the properties or visual layout and look of a document |
|
Formulae |
Expressions used to calculate data to produce a desired result |
|
Headers / footers |
Areas, either in the top (header) or bottom (footer) of documents, that can contain document information that repeats on all printed pages |
|
Legend |
Explanatory text that describes the meaning of chart elements |
|
Multiplication |
A function that calculates by multiplying cell entries |
|
Recycling |
The reusing of objects. For example, in a business environment this can refer to
|
| Spreadsheet | A computer program that displays data in rows and columns on a screen, and lets you create and manipulate numerical data electronically |
Subtraction |
A function that calculates the numerical difference between cell entries |
Sum |
A function which is used to add the numbers in a range of cells |
Text |
Words treated as data by a computer |