Question

choose the correct answer.
which of the following shows the correct syntax for summing the selected data?
=sum(b2:b7)
=b2:b7

Explanation:

Step1: Analyze the formula =SUM(B2:B7)

The SUM function in spreadsheet software is specifically designed to add up a range of cells. Here, B2:B7 is the range of cells containing the expense values. The SUM function will calculate the sum of all the values in that range.

Step2: Analyze the formula =B2:B7

This formula just references the range of cells B2 to B7. It does not perform any calculation (such as summing). It is not a valid formula for getting the sum of the values in those cells.

Answer:

=SUM(B2:B7)