Question

In cell E12, create a formula using the SUM function to total the values in the range E4:E11.

a) =SUM(E4:E11)
b) =TOTAL(E4:E11)
c) =SUM(E12:E4,E11)
d) =ADD(E4:E11)

Answer 1

In Excel, to sum up a range of cells such as E4:E11, the correct formula is =SUM(E4:E11), and it would be entered into cell E12.

To total the values in the range E4:E11 in cell E12 using the SUM function, you would use the formula =SUM(E4:E11). This formula will add up all the values contained within cells E4 through E11 and display the result in cell E12. It's important to remember that the SUM function is the correct function to use for totaling numbers in Excel, and proper range specification is crucial.