Spreadsheet, Contains one or more worksheets which are used to present and manipulate data. , Data Type, Defines the type of data associated with the field eg string, Cell Reference, The address or location of a certain cell, Conditional Formatting, Used to change the appearance of a cell based on certain conditions, Data Validation, ensures that data entered is reasonable, sensible and within acceptable boundaries, Template, A pre-designed document which can be edited and customised by the user, Formula, A calculation represented in a cell using mathematical symbols and references to other cells, Function, A ready-made formula, V Look Up, Uses the value in a selected cell to find a match in the column of a look up table, Absolute Cell Reference, A cell reference which does not change when copied or replicated, Chart Legend, Used as part of a chart to identify data, Macro, A set of commands recorded together, activated by a mouse click or pressing a key, Cell Range, A group of cells in a selection from the upper left cell to the lower right cell, Header, Improves the presentation of worksheets, often placed at the top of a document, Footer, Improves the presentation of worksheets, often placed at the bottom of a document.

Spreadsheet Glossary

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?