Flashcards
Topic 10
Flashcards do conjunto (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
Informações
- Descrição
- FlashCards sobre Topic 10, criado por sanaa_mirza em 13-02-2015.
- Criado por
- sanaa_mirza · fev 2015
- Atualizado
- 19 fev 2016
- Visualizações
- 0
- Avaliação