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
