Question

question 10 of 25
you want to add together the contents of three cells in your spreadsheet: b1, c3, and d5. which three formulas could you use?

a. b1c3d5
b. sum(b1+c3+d5)
c. b1+c3+d5
d. sum(b1:c3:d5)

Explanation:

• Option A: \( B1*C3*D5 \) is a multiplication operation, not addition, so it's incorrect.
• Option B: The SUM function in spreadsheets can take a formula for addition as an argument. \( \text{SUM}(B1 + C3 + D5) \) will add the values of B1, C3, and D5.
• Option C: In most spreadsheet software, directly using \( B1 + C3 + D5 \) will add the contents of the three cells.
• Option D: The range notation \( B1:C3 \) includes cells B1, B2, B3, C1, C2, C3, and then adding D5 with this range in the SUM function is not the correct way to add just B1, C3, and D5. So this formula is incorrect.

Answer:

B. \( \text{SUM}(B1 + C3 + D5) \), C. \( B1 + C3 + D5 \)