Flashcards
Topic 10 - Spreadsheets
Flashcards do 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.
Informações
- Descrição
- FlashCards sobre Topic 10 - Spreadsheets, criado por prasm001 em 05-03-2015.
- Criado por
- prasm001
- Visualizações
- 0
- Avaliação