Flashcards
Spreadsheets revision
Cards in this deck (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
Information
- Description
- Flashcards on Spreadsheets revision, created by ephre007 on 13/02/2015.
- Created by
- ephre007
- Views
- 1
- Rating