Which of the following formulas most efficiently totals the values in cells B6, B7, B8, B9, and B10 in a spreadsheet?
A
=AVERAGE(B6:B10)
B
=SUM(B6:B10)
C
=B6+B7+B8+B9+B10
D
=SUM(B6,B7,B8,B9,B10)
0 댓글
검증된 단계별 안내
1
Understand the problem: The goal is to determine which formula efficiently totals the values in cells B6, B7, B8, B9, and B10 in a spreadsheet.
Review the options provided: Analyze each formula to see if it calculates the sum of the values in the specified cells.
Option 1: =AVERAGE(B6:B10) - This formula calculates the average of the values in the range B6 to B10, not the sum. Therefore, it is not correct.
Option 2: =SUM(B6:B10) - This formula uses the SUM function to efficiently add all the values in the range B6 to B10. It is correct and efficient.
Option 3: =B6+B7+B8+B9+B10 - This formula manually adds each cell value. While it calculates the sum, it is less efficient than using the SUM function.
Option 4: =SUM(B6,B7,B8,B9,B10) - This formula uses the SUM function but lists each cell individually instead of using a range. It works but is less efficient than =SUM(B6:B10).