SSTerminology

=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**__=

__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
 * 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**

__'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