Karteikarten
Ohne Titel
Karten in diesem Stapel (9)
- 1What is a label?any text in a cell describing the data in a row or in a column (titles, headings that identify data)
- 2What is Data?Any values (text or numbers0 that are entered for the use of calculation
- 3What are formulas and functions?mathematical calculations carried out automatically
- 4Formulasmust start with an =
Formulas perform calculations on cell contents.
Formulas appear in the formula bar.
The 4 main operation are
+ add
-minus
* multiply
/divide - 5FormattingThe content of a cell can be formatted: font style,size,colour,border style, alignment ,cell colour.
Multiple cells can be merged into one. - 6Replicating cellswhen you position the mouse pointer in the bottom right hand corner and drag down or across the spread sheet tries to respond intelligently.
- 7What if calculationsChanging the data in a spread sheet model allows you to make and test predictions. You may explore what would happen to your profit if VAT changed to 30%. These are know as what if calculations.
- 8Relative Cell ReferencingA cell is used in a formula and the formula is copied to a new cell reference (address), the cell references changes to take account of the formulas new position.
- 9Absolute Cell ReferencingIs where a reference to a cell used in a formula where, when a formula is copied to a new cell reference, the cell reference does not change. It is glued in place by the $ character.
Informationen
- Beschreibung
- Karteikarten am Ohne Titel, erstellt von Pavan Badyal am 13/02/2015.
- Erstellt von
- Pavan Badyal
- Aufrufe
- 0
- Bewertung