Flashcards
Topic 10 - Spreadsheets
Cards in this deck (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.
Information
- Description
- Flashcards on Topic 10 - Spreadsheets, created by prasm001 on 05/03/2015.
- Created by
- prasm001
- Views
- 0
- Rating