Spreadsheet & Modelling Terminology

Update this page with the terminology for these terms:
Key terms—cell, cell format (number, text, value, function, calculation, date, currency), row, column, label, macro, replicate, template, worksheet, “what if” questions, range, absolute and relative reference
Paper files versus electronic files
• Reliability and integrity of data
Storage and access concepts
• Data transfer between a database and a spreadsheet
Presentation concepts
• Select print and display area of a worksheet
• Use of the appropriate graph or chart for the meaningful representation of information
• Special-purpose spreadsheets, for example, inventory, budget

and


key terms—model, simulation, feedback loop
• faulty or hidden assumptions
• extent and effect of the simplification of reality
• extent to which the phenomenon being modelled is understood
• processing power needed to create complex models
• visualization of information
• correspondence of the model with reality.

Terminology

1. Cell
2. Cell format
3. Row
4. Column
5. Label
6. Macro
7. Replicate
8. Template
9. Worksheet
10. "What if" command
11. Range
12. Absolute cell reference
13. Relative cell reference

Cell

Macro
Macros are small program that can automate common tasks. In spreadsheet, a user can record a macro, which can format the data in selected columns. In the below example, the ‘run’ button is seen where, when user click it would format the selected cell

'What if' commands
'What if' commands are often used to predict what would happen if a particular data is changed.

Absolute Cell Refernece
"Absolute cell reference is when a formula typed in a particular cell does not apply to other cell that follows. In spreadsheet applications, a reference to a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell." [webopedia]
Absolute cell reference uses '$' sign, for example 'A$3$'. The dollar sign prevents a particular formula from applying itself to other cells.

Cell Format
To change the format and appearance of selected cell(s), row(s) or column(s) use the Cell Format... option from the Format menu or from the right mouse button popup menu.


Replication
To duplicate, copy, reproduce, or repeat a cell or data.

Back