Flashcards
CAT Practical - Excel
Flashcards do conjunto (17)
- 1What is the function of this formula? =sum(A1:B1)Sum
- 2What is a formula argument?The argument of a formula refer to the cells in which the data is to which the function applies.
- 3What is the argument of this formula? =sum(A1:B1)A1:B1
- 4What is the function of the following formula? SumCalculates the sum or total of the arguments
- 5What is the function of the following formula? AverageCalculates the average value of the selected cells.
- 6What is the function of the following formula? MinCalculates the minimum/least value of the selected cells.
- 7What is the function of the following formula? MaxCalculate the maximum/highest value of the selected cells.
- 8What is the function of the following formula? NOWInserts the current time and date of the computer into the cell.
- 9How can a cell containing the following formula be updated? =now()By clicking on the cell and pressing enter.
- 10What is the function of the following formula? TIMETo calculate the subtraction, division, adding or multiplying of hours, minutes and seconds.
- 11Rephrase the following formula in words. =2^2Two to the power of two.
- 12Why could the following error appear? #VALUE!The data inserted in the selected formula is incorrect or does not apply to the formula.
- 13How can you fix the following error?By ensuring all data inserted in to the cells are correct and are applicable.
- 14Why could the following error appear? #DIV/0This error occurs when an cell must be divided by zero.
- 15Why could the following error appear? #NAME?The function name is invalid.
- 16Why could the following error appear? #REF!When a column or row that had been deleted are selected in a formula.
- 17Why could the following error appear? #NUM!The cell is too small to display the number calculated.
Informações
- Descrição
- 10 Computer Appliance Technology FlashCards sobre CAT Practical - Excel, criado por J Barnes em 31-08-2016.
- Criado por
- J Barnes
- Visualizações
- 1
- Tags
- Avaliação