Fichas
Topic 10 - Spreadsheets
Fichas del conjunto (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.
Información
- Descripción
- Fichas sobre Topic 10 - Spreadsheets, creado por prasm001 el 05/03/2015.
- Creado por
- prasm001
- Visitas
- 0
- Valoración