1. Which formula would you use to calculate the total of values in cells A1 to A10?
- A)
=SUM(A1:A10) - B)
=TOTAL(A1:A10) - C)
=ADD(A1:A10) - D)
=SUMTOTAL(A1:A10)
Answer: A) =SUM(A1:A10)
2. What does the formula =AVERAGE(B1:B5) compute?
- A) The sum of values in cells B1 to B5
- B) The average of values in cells B1 to B5
- C) The maximum value in cells B1 to B5
- D) The number of values in cells B1 to B5
Answer: B) The average of values in cells B1 to B5
3. How can you find the smallest value in a range of cells from C1 to C20?
- A)
=MIN(C1:C20) - B)
=SMALLEST(C1:C20) - C)
=LOWEST(C1:C20) - D)
=MINIMUM(C1:C20)
Answer: A) =MIN(C1:C20)
4. To count the number of cells containing numbers in the range D1 to D10, which function is used?
- A)
=COUNT(D1:D10) - B)
=COUNTA(D1:D10) - C)
=COUNTIF(D1:D10, “>0”) - D)
=SUM(D1:D10)
Answer: A) =COUNT(D1:D10)
5. Which formula is correct for finding the highest value in cells E1 through E10?
- A)
=MAX(E1:E10) - B)
=LARGEST(E1:E10) - C)
=HIGHEST(E1:E10) - D)
=MAXIMUM(E1:E10)
Answer: A) =MAX(E1:E10)
6. What does the formula =SUM(A1:A3) - B1 calculate if A1=10, A2=20, A3=30, and B1=15?
- A) 45
- B) 65
- C) 55
- D) 35
Answer: C) 55
7. Which function would you use to find the average of values in cells F1 through F5?
- A)
=MEAN(F1:F5) - B)
=AVERAGE(F1:F5) - C)
=SUM(F1:F5)/5 - D)
=AVG(F1:F5)
Answer: B) =AVERAGE(F1:F5)
8. How do you determine the total number of non-empty cells in the range G1 to G10?
- A)
=COUNTA(G1:G10) - B)
=COUNT(G1:G10) - C)
=SUM(G1:G10) - D)
=TOTAL(G1:G10)
Answer: A) =COUNTA(G1:G10)
9. To calculate the sum of values in cells H1, H2, and H3 and then find the average, which formula would you use?
- A)
=SUM(H1:H3)/3 - B)
=AVERAGE(H1:H3) - C)
=SUM(H1:H3,AVERAGE(H1:H3)) - D)
=SUM(H1:H3)/AVERAGE(H1:H3)
Answer: A) =SUM(H1:H3)/3
10. What does the formula =MAX(A1:A5) - MIN(A1:A5) calculate?
- A) The sum of the maximum and minimum values in the range A1 to A5
- B) The difference between the maximum and minimum values in the range A1 to A5
- C) The average of the maximum and minimum values in the range A1 to A5
- D) The product of the maximum and minimum values in the range A1 to A5
Answer: B) The difference between the maximum and minimum values in the range A1 to A5