Flashcards
Spreadsheets revision
Flashcards do conjunto (8)
- 1Give two advantages of using a spread sheet to work out a profit or loss1. accurate calculations
2. automatic recalculation - 2What type of cell referencing is used in this formula "A3*$B$1$" ?Absolute cell referencing
- 3What is a "what-if" calculation?What if calculations allow you to use the spread sheet to see what would happen is you changed certain figures in the spread sheet. they are used to predict outcomes
- 4What is meant by a label?A label is used for titles, headings, names and for identifying columns or rows of data
- 5What is meant by data?Data are the values (text or numbers) that you enter into the spreadsheet.
- 6What is meant by a formula?Formulas are used to perform calculations on the cell contents
- 7Name the two types of cell referenceAbsolute and relative
- 8What is absolute cell referencing?Is where a reference to a cell used in a formula where, when the formula is copied to a new cell reference (cell address), the cell reference doesn't change. Its glued in place by the $ character
Informações
- Descrição
- FlashCards sobre Spreadsheets revision, criado por ephre007 em 13-02-2015.
- Criado por
- ephre007
- Visualizações
- 1
- Avaliação