Question

question 5 of 10
a formula in cell d1 of this spreadsheet gives a result of 10. which formula
was most likely entered in cell d1?

	a	b	c	d
1	8	7	6	10
2	9	6	3
3	1	4	7

a. =b2-b3
b. =a2/c2
c. =a1*a3
d. =c2+c3

Explanation:

Step1: Analyze Option A

Formula: $=B2 - B3$
B2 is 6, B3 is 4. So $6 - 4 = 2
eq 10$.

Step2: Analyze Option B

Formula: $=A2/C2$
A2 is 9, C2 is 3. So $\frac{9}{3}= 3
eq 10$.

Step3: Analyze Option C

Formula: $=A1*A3$
A1 is 8, A3 is 1. So $8 * 1 = 8
eq 10$. Wait, correction: Wait, A1 is 8, A3 is 1? Wait no, A1 is 8, A3 is 1? Wait, no, let's recheck. Wait A1 is 8, A3 is 1? Wait, no, the table: Row 1: A1=8, B1=7, C1=6, D1=10. Row 2: A2=9, B2=6, C2=3. Row 3: A3=1, B3=4, C3=7. Wait, Option C: =A1A3. A1=8, A3=1. 81=8. No. Wait, maybe I made a mistake. Wait Option D: =C2 + C3. C2=3, C3=7. 3+7=10. Oh! I messed up. Let's redo:

Step1: Analyze Option A

Formula: $=B2 - B3$
B2 = 6, B3 = 4. $6 - 4 = 2
eq 10$.

Step2: Analyze Option B

Formula: $=A2/C2$
A2 = 9, C2 = 3. $\frac{9}{3}= 3
eq 10$.

Step3: Analyze Option C

Formula: $=A1*A3$
A1 = 8, A3 = 1. $8 * 1 = 8
eq 10$.

Step4: Analyze Option D

Formula: $=C2 + C3$
C2 = 3, C3 = 7. $3 + 7 = 10$. Which matches D1's result. So Option D is correct.

Answer:

D. =C2+C3