Q1: What is the cell reference $A$1 called?
- a) relative cell reference
- b) absolute cell reference
- c) mixed cell reference
- d) all of the above
Q2: What is the cell reference A1 called?
- a) relative cell reference
- b) absolute cell reference
- c) mixed cell reference
- d) all of the above
Q3: When does the ‘OR’ operator shows ‘TRUE’ value?
- a) when all conditions are false
- b) when all condition are true
- c) when any one condition is true
- d) both b and c
Q4: What are the three types of data found in spreadsheet?
- a) data, words, numbers
- b) numbers, formulae, labels
- c) equations, data, numbers
- d) words, numbers, labels
Q5: To merge the cells which tool is used?
- a) merge
- b) number
- c) alignment
- d) all of the above
