1. Which formula is used to calculate the sum of cells A1 through A10?
- A)
=SUM(A1:A10) - B)
=TOTAL(A1:A10) - C)
=ADD(A1:A10) - D)
=SUM(A1,A2,A3,A4,A5,A6,A7,A8,A9,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. What does the formula =IF(E1>50, "Pass", "Fail") do?
- A) Checks if E1 is greater than 50 and returns “Pass” if true, otherwise “Fail”
- B) Adds 50 to the value in E1 and returns “Pass”
- C) Subtracts 50 from E1 and returns “Fail” if the result is less than zero
- D) Multiplies E1 by 50 and returns “Pass” if the result is greater than 50
Answer: A) Checks if E1 is greater than 50 and returns “Pass” if true, otherwise “Fail”
6. How do you find the number of characters in cell F1?
- A)
=LENGTH(F1) - B)
=CHARCOUNT(F1) - C)
=LEN(F1) - D)
=COUNTCHARS(F1)
Answer: C) =LEN(F1)
7. Which function would you use to concatenate the values in cells G1 and G2?
- A)
=JOIN(G1, G2) - B)
=COMBINE(G1, G2) - C)
=CONCATENATE(G1, G2) - D)
=MERGE(G1, G2)
Answer: C) =CONCATENATE(G1, G2)
8. To compute the compound interest using the future value function, you use:
- A)
=FV(rate, nper, pmt, [pv], [type]) - B)
=PV(rate, nper, pmt, [fv], [type]) - C)
=IRR(rate, nper, pmt, [pv], [type]) - D)
=NPV(rate, nper, pmt, [pv], [type])
Answer: A) =FV(rate, nper, pmt, [pv], [type])
9. What is the function to calculate the total value of cells H1 to H10 excluding errors?
- A)
=SUMIF(H1:H10, "<>#N/A") - B)
=SUM(H1:H10) - C)
=AGGREGATE(9, 6, H1:H10) - D)
=SUMIF(H1:H10, "<>")
Answer: C) =AGGREGATE(9, 6, H1:H10)
10. How do you apply a formula to multiple cells at once?
- A) Use the Fill Handle to drag the formula to other cells
- B) Copy the formula and paste it into other cells
- C) Manually enter the formula in each cell
- D) Use the AutoSum feature
Answer: A) Use the Fill Handle to drag the formula to other cells