Flashcards
Topic 10
Cards in this deck (13)
- 1CellsA cell reference always starts with a letter and ends with a number e.g. A5 or H28, a range of cells is a set of cells in a row or column, data entered into cells can be different data types e.g. text, number, currency, date, percentage
- 2LabelsAny text in a cell describing the data in a row or column(titles, headings that identify data)
- 3DataAny values (text or numbers) that are entered for the use of calculation
- 4Formulas and functionsMathematical calculations carried out automatically
- 5FormulasMust start with and equals sign
- 6FormattingThe content of a cell can be formatted
- 7Replicating cellsPositioning the mouse pointer in the bottom right hand corner of a cell and drag down or across a spreadsheet to replicate it
- 8Graphs and ChartsAllows us to notice patterns and trends easier, can be selected on a spreadsheet
- 9Cell ReferencingWhen a formula is copied by filling down the cell refernces
- 10Relative cell referenceNo $ sign
- 11Absoloute cell referencingA $ sign is used
- 12What if calculationsWhen you change the data in a spreadsheet and you are allowed to make and test predictions
- 13Benefits of using a spreadsheetAutomatic recalculation, accurate calculations, graphs/charts, replication
Information
- Description
- Flashcards on Topic 10, created by sanaa_mirza on 13/02/2015.
- Created by
- sanaa_mirza · Feb 2015
- Updated
- Feb 19, 2016
- Views
- 0
- Rating