Quiz
Untitled
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (6)
1A label is...
- Aany text in a cell describing the data in a row or column (titles, headings that identify data)
- Bany values (text or numbers) that are entered for the use of calculation
2Cell referencing is when...
- AWhen a formula is copied by 'filling down' the cell references in cells are adjusted as you drag the pointer down the page
- BWhen a cell is used in a formula and the formula is copied to a new reference (address), the cell references (cell address) changes to take account of the formula's new position
3Absolute cell referencing is when...
- AWhen the content of a cell is changed, calculations are performed and other cells are updated if necessary
- BWhere 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 (cell address) does not change. It is glued in place by the $ character
4Examples of functions are...
- ASUM, COUNT, AVERAGE, MIN, MAX, IF
- B+ ADD, - SUBTRACT, * MULTIPLY, / DIVIDE
5A workbook is...
- AA single tab in the spreadsheet
- BA spreadsheet application such as Excel can store all its data in a single file (with an .xls extension)
6Data types include...
- AFont style, size, colour, border style, alignment, cell colour
- BCurrency, number, real, integer (whole number), data, text
Information
- Description
- Quiz on Untitled, created by aujlg001 on 08/03/2015.
- Author
- aujlg001
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz