1. Which symbol must a formula in Excel always begin with?
(A) +
(B) =
(C) $
(D) #
2. The function =SUM(A1:A5) will:
(A) Add the values in cells A1 to A5
(B) Multiply the values in cells A1 to A5
(C) Count the number of cells in A1 to A5
(D) Subtract A5 from A1
3. The function =AVERAGE(10,20,30) will return:
(A) 25
(B) 30
(C) 15
(D) 20
4. Which function counts only numeric values in a range?
(A) COUNTA
(B) COUNTIF
(C) COUNT
(D) COUNTBLANK
5. Which function counts all non-empty cells in a range (including text and numbers)?
(A) COUNTA
(B) COUNT
(C) COUNTBLANK
(D) SUM
6. The function =IF(5>3,"Yes","No") will return:
(A) No
(B) Yes
(C) Error
(D) 5>3
7. The formula =MAX(12,45,32,17) will return:
(A) 12
(B) 17
(C) 32
(D) 45
8. Which function is used to find the smallest value in a range?
(A) LOWER
(B) SMALL
(C) MIN
(D) LEAST
9. The function =COUNTBLANK(A1:A10) will:
(A) Count only numeric values in the range
(B) Count all non-empty cells in the range
(C) Count the number of empty cells in the range
(D) Return an error
10. Which function returns the current system date in Excel?
(A) TIME()
(B) NOW()
(C) DATE()
(D) TODAY()