1) Which function is used to find the total of a range of cells in Excel? a) A. COUNT b) B. AVERAGE c) C. SUM d) D. MAX 2) What does the AVERAGE function in Excel return? a) A. The highest number b) B. The total number of cells c) C. The middle number d) D. The mean of the numbers 3) Which function is used to find square root of a value ? a) A. SQUARE ROOT b) B. SQUARE c) C. SQRT d) D. ROOT 4) What does the MAX function do in Excel? a) A. Finds the smallest value b) B. Adds all numbers c) C. Returns the highest value d) D. Finds the average 5) What does the MIN function return? a) Maximum value b) Average value c) Total sum d) Minimum value 6) Which of the following is the correct syntax of the AVERAGE function? a) =AVERAGE(A1:A10) b) =AVG(A1:A10) c) =MEAN(A1:A10) d) =AVER(A1:A10) 7) Which of the following correctly represents the syntax of the IF function? a) =IF[condition, true, false] b) =IF(condition; true; false) c) IF(condition; result) d) =IF(logical_test, value_if_true, value_if_false) 8) What will be the result of =IF(5>3, "Yes", "No")? a) A. Yes b) B. No c) C. Error d) D. 5>3 9) Which of the following formulas correctly uses the MOD function? a) MOD=10,3 b) =MOD(10,3) c) =MOD(3,10) d) =MOD(10:3) 10) What is the main purpose of the SUM function in Excel? a) To subtract numbers b) To count non-empty cells c) To add a range of numbers d) To find the average

"Function Detective"

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?