Asked by moses munyai on May 26, 2024
Verified
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
A) The formula =B6+B7+B8+B9+B10.
B) The formula =TOTAL(B6-B10)
C) The formula =SUM(B6:B10)
D) The formula +SUM(B6-B10)
Sum Function
A mathematical function used in spreadsheets and databases to add together a series of numbers or cells.
Total Function
A type of function in mathematics and computer science that is defined for all possible inputs from its domain.
- Learn to carry out basic mathematical operations and employ functions in Excel.
Verified Answer
IR
Irsal RosliMay 27, 2024
Final Answer :
C
Explanation :
The formula =SUM(B6:B10) is the most efficient because it allows for all the cells to be included in the range without individually typing out each cell. Additionally, it uses a built-in function specifically designed to calculate the sum of a range of cells.
Learning Objectives
- Learn to carry out basic mathematical operations and employ functions in Excel.