Flashcards

Untitled

Pavan Badyal English 9 cards

Cards in this deck (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.