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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?