Quiz
CAT PAT
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
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()- AVerdadeiro
- BFalso
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!- AVerdadeiro
- BFalso
13The following error cannot be fixed.
#DIV/0- AVerdadeiro
- BFalso
14The following error cannot be fixed.
#NAME?- AVerdadeiro
- BFalso
15The following error can be fixed.
#REF!- AVerdadeiro
- BFalso
16The following errors can be solved by double clicking.
#NUM!- AVerdadeiro
- BFalso
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.
Informações
- Descrição
- 10 Computer Appliance Technology Quiz sobre CAT PAT, criado por J Barnes em 31-08-2016.
- Autor
- J Barnes
- Idioma
- English
- Visualizações
- 1
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz