Question

which formula below will sum cells b2 through b14?

• =sum(b2:b14)
• =sum(b2-b14)
• =sum b(1-14)
• none of the above

Explanation:

Identify the target cells and operation

The question asks for a formula to sum cells B2 through B14.

Analyze standard spreadsheet syntax

In spreadsheet software (such as Microsoft Excel or Google Sheets), a continuous range of cells from a starting cell to an ending cell is represented using a colon : operator. Therefore, the range "B2 through B14" is written as B2:B14.

Evaluate the given options

• =SUM(B2:B14) uses the correct function name and range syntax.
• =SUM(B2-B14) uses a subtraction operator, which subtracts B14 from B2 instead of defining a range.
• =SUM B(1-14) is syntactically invalid.
• "None of the above" is incorrect because the first option is correct.

Answer:

• =SUM(B2:B14) (Correct answer)
• =SUM(B2-B14)
• =SUM B(1-14)
• None of the above