In Excel, which formula would you use to sum the values from cell B2 to B4?

Correct option is C

The SUM function is used in Excel to add the values of multiple cells. By using =SUM(B2:B4), you can add all the values from cell B2 to cell B4.
Important Key Points:
1. SUM Function: The SUM function in Excel is the most commonly used formula for adding multiple cells or ranges of cells.
2. Colon (:) Usage: In B2:B4, the colon represents a range, indicating all cells from B2 to B4 should be included in the summation.
Knowledge Booster:
· =B2 + B4: This would only add the values in B2 and B4, but it does not sum the range B2, B3, and B4.
· =ADD(B2:B4) and =TOTAL(B2:B4): These are incorrect functions in Excel as there are no ADD or TOTAL functions for this purpose.
· SUM Range: The SUM function can be used to sum larger ranges as well, such as =SUM(A1:D10), to quickly add values across rows and columns.