Quiz
CAT PAT
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem 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- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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()- ARichtig
- BFalsch
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!- ARichtig
- BFalsch
13The following error cannot be fixed.
#DIV/0- ARichtig
- BFalsch
14The following error cannot be fixed.
#NAME?- ARichtig
- BFalsch
15The following error can be fixed.
#REF!- ARichtig
- BFalsch
16The following errors can be solved by double clicking.
#NUM!- ARichtig
- BFalsch
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.
Informationen
- Beschreibung
- 10 Computer Appliance Technology Quiz am CAT PAT, erstellt von J Barnes am 31/08/2016.
- Autor
- J Barnes
- Sprache
- English
- Aufrufe
- 1
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz