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 first formula

The SUM function in spreadsheet software is used to sum a range of cells. The syntax =SUM(B2:B7) is correct as it uses the SUM function to add up the values in cells from B2 to B7.

Step2: Analyze the second formula

The formula =B2:B7 is not a valid formula for summing. It just represents a range of cells but does not perform the summation operation.

Answer:

=SUM(B2:B7)