Test
CAT PAT
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (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- AVerdadero
- 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.
- AVerdadero
- 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()- AVerdadero
- 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!- AVerdadero
- BFalso
13The following error cannot be fixed.
#DIV/0- AVerdadero
- BFalso
14The following error cannot be fixed.
#NAME?- AVerdadero
- BFalso
15The following error can be fixed.
#REF!- AVerdadero
- BFalso
16The following errors can be solved by double clicking.
#NUM!- AVerdadero
- 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.
Información
- Descripción
- 10 Computer Appliance Technology Test sobre CAT PAT, creado por J Barnes el 31/08/2016.
- Autor
- J Barnes
- Idioma
- English
- Visitas
- 1
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test