Business Services

Home > Business Services > Business Services (120/240 hours) > Create and use simple spreadsheets > Create and use simple spreadsheets

Key terms and concepts

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

  • sending used paper for remanufacture/using paper that has been remanufactured
  • reusing office stationery, such as envelopes
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

Go To Top

Back to contents



Neals logo | Copyright | Disclaimer | Contact Us | Help