1. Which formula would you use to add the values in cells A1 and A2?
- A)
=A1+A2 - B)
=SUM(A1,A2) - C)
=ADD(A1,A2) - D) Both A and B
Answer: D) Both A and B
2. How can you subtract the value in cell B2 from the value in cell B1?
- A)
=SUBTRACT(B1,B2) - B)
=B1-B2 - C)
=DIFFERENCE(B1,B2) - D)
=B2-B1
Answer: B) =B1-B2
3. Which formula is correct for multiplying the values in cells C1 and C2?
- A)
=C1*C2 - B)
=MULTIPLY(C1,C2) - C)
=PRODUCT(C1,C2) - D)
=C1+C2
Answer: A) =C1*C2
4. To divide the value in cell D1 by the value in cell D2, which formula should you use?
- A)
=D1/D2 - B)
=DIVIDE(D1,D2) - C)
=QUOTIENT(D1,D2) - D)
=D2/D1
Answer: A) =D1/D2
5. What is the result of the formula =SUM(A1:A3) - B1 if A1=10, A2=20, A3=30, and B1=15?
- A) 45
- B) 65
- C) 55
- D) 35
Answer: C) 55
6. If you want to add the values in cells E1 through E5 and then subtract the value in cell F1, which formula would you use?
- A)
=SUM(E1:E5)-F1 - B)
=SUM(E1:F1) - C)
=SUM(E1:E5,F1) - D)
=SUM(E1:E5)-SUM(F1)
Answer: A) =SUM(E1:E5)-F1
7. Which formula correctly multiplies the sum of cells G1 and G2 by the value in cell G3?
- A)
=SUM(G1,G2)*G3 - B)
=(G1+G2)*G3 - C)
=MULTIPLY(SUM(G1:G2),G3) - D) Both A and B
Answer: D) Both A and B
8. To find the average of values in cells H1, H2, and H3 and then divide by the value in cell H4, which formula should you use?
- A)
=AVERAGE(H1:H3)/H4 - B)
=SUM(H1:H3)/3/H4 - C)
=SUM(H1,H2,H3)/3/H4 - D) Both A and C
Answer: D) Both A and C
9. How would you write a formula to add the values in cells I1 and I2, multiply the result by the value in I3, and then divide by the value in I4?
- A)
=(I1+I2)*I3/I4 - B)
=SUM(I1:I2)*I3/I4 - C)
=PRODUCT(I1+I2,I3)/I4 - D) Both A and B
Answer: D) Both A and B
10. What does the formula =SUM(J1:J5)*K1/L1 do?
- A) Adds the values in J1 to J5, multiplies by the value in K1, then divides by the value in L1
- B) Multiplies the values in J1 to J5, adds the value in K1, then divides by L1
- C) Divides the sum of J1 to J5 by K1 and then multiplies by L1
- D) Multiplies the sum of J1 to J5 by L1 and then divides by K1
Answer: A) Adds the values in J1 to J5, multiplies by the value in K1, then divides by the value in L1