Flashcards
CAT Practical - Excel
Cards in this deck (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.
Information
- Description
- 10 Computer Appliance Technology Flashcards on CAT Practical - Excel, created by J Barnes on 31/08/2016.
- Created by
- J Barnes
- Views
- 1
- Tags
- Rating