Karteikarten
Topic 10 - Spreadsheets
Karten in diesem Stapel (9)
- 1CellsEach cell can contain labels, data, formulas and functions.
- 2FormulasFormulas perform calculations on cell contents. The result of the formula is automatically recalculated every time you alter the data in a cell.
- 3Functionsfunctions are part of spreadsheet software. they are specialised calculations built in to the spreadsheet software.
- 4Formattingthe content of a cell can be formatted: font style, size, colour, border style, alignment and cell colour.
- 5replicating cellsposition the mouse pointer in the lower right hand corner of a cell and drag down to replicate the contents of that cell.
- 6graphs and chartsusing charts and graphs allows you to notice trends and patterns.
- 7relative cell referencingif a formula is copied by filling down, the cell references are adjusted as you drag the replication pointer downwards.
- 8absolute cell referencingsometimes we need part of a formula to stay the same so we use absolute cell referencing. all other cell references will change but these will stay the same when dragging down to replicate cells.
- 9benefits of using a speadsheetAUTOMATIC RECALCULATION: every time the content of a cell is altered, calculations are performed and other cells are updated.
ACCURATE CALCULATIONS: providing the formula is correct, the calculations will be accurate.
Informationen
- Beschreibung
- Karteikarten am Topic 10 - Spreadsheets, erstellt von prasm001 am 05/03/2015.
- Erstellt von
- prasm001
- Aufrufe
- 0
- Bewertung