Quiz
CAT PAT
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 (19)
1What is the function of this formula?
=sum(A1:B1)- A=
- Bsum
- C(A1:B1)
- DA1:B1
- E()
2What is a formula argument?
- AThe argument of a formula refer to the cells in which the data is to which the function applies.
- BThe argument of a formula refer to the coloums in which the data is to which the function applies.
- CThe argument of a formula refer to the row in which the data is to which the function applies.
3What is the argument of this formula?
=sum(A1:B1)- AA1:B1
- B=
- Csum
- D(A1:B1)
- E()
4The function of the following formula is to calculate the sum or total of the arguments.
Sum- ATrue
- BFalse
5Which formula would be best suited to calculate the average value of the selected cells?
- AAverage
- BMax
- CMin
- DSum
6The formula 'min' is used to calculate the maximum/highest value of the selected cells.
- ATrue
- BFalse
7What is the function of the following function?
Max- ACalculate the maximum/highest value of the selected cells.
- BCalculates the minimum/least value of the selected cells.
- CCalculates the average value of the selected cells.
- DCalculates the sum or total of the arguments
8The following formula is permanent and cannot be updated.
=Now()- ATrue
- BFalse
9What is the following symbol used for during excel?
^- ATo multiply
- BTo devide
- CTo the power of
10What is the function of the following formula?
TIME- ATo calculate the subtraction, division, adding or multiplying of hours, minutes and seconds.
- BInserts the current time and date of the computer into the cell.
- CCalculate the maximum/highest value of the selected cells.
- DCalculates the minimum/least value of the selected cells.
11Why could the following error appear?
#VALUE!- AThe data inserted in the selected formula is incorrect or does not apply to the formula.
- BThis error occurs when an cell must be divided by zero.
- CThe function name is invalid.
- DWhen a column or row that had been deleted are selected in a formula.
- EThe cell is too small to display the number calculated.
12The following error cannot be reversed.
#VALUE!- ATrue
- BFalse
13The following error cannot be fixed.
#DIV/0- ATrue
- BFalse
14The following error cannot be fixed.
#NAME?- ATrue
- BFalse
15The following error can be fixed.
#REF!- ATrue
- BFalse
16The following errors can be solved by double clicking.
#NUM!- ATrue
- BFalse
17Why could the following error appear?
#DIV/0- AThis error occurs when an cell must be divided by zero.
- BThe data inserted in the selected formula is incorrect or does not apply to the formula.
- CThe function name is invalid.
- DWhen a column or row that had been deleted are selected in a formula.
- EThe cell is too small to display the number calculated.
18Why could the following error appear?
#NAME?- AThe function name is invalid.
- BThis error occurs when an cell must be divided by zero.
- CThe data inserted in the selected formula is incorrect or does not apply to the formula.
- DWhen a column or row that had been deleted are selected in a formula.
- EThe cell is too small to display the number calculated.
19Why could the following error appear?
#NUM!- AThe cell is too small to display the number calculated.
- BWhen a column or row that had been deleted are selected in a formula.
- CThe function name is invalid.
- DThis error occurs when an cell must be divided by zero.
- EThe data inserted in the selected formula is incorrect or does not apply to the formula.
Information
- Description
- 10 Computer Appliance Technology Quiz on CAT PAT, created by J Barnes on 31/08/2016.
- Author
- J Barnes
- Language
- English
- Views
- 1
- Tags
- Rating
- No ratings yet Rate this quiz