If you wanted to add cells A1, and A4 through A6 together, which would be the best formula to use?

Answer 1

=SUM(A1:A6)

Answer 2

=SUM(A1,A4,A5,A6)

Answer 3

=SUM(A1,A4:A6)

Answer 4

Don’t know

Answer 5

=SUM(B4:B15)

Answer 6

=SUM(B4,B9:B15)

Answer 7

=SUBTOTAL(9,B4:B15)

Answer 8

Don’t know

Answer 9

Select A5, go to the Home tab, and press the Decrease decimal button on the Number group twice.

Answer 10

=ROUND(A5,0)

Answer 11

=ROUND(A5,-1)

Answer 12

Don’t know

There is data in the cells B4:B15, with the following formula used to subtotal the data in B9: =SUBTOTAL(9,B5:B8). Which would be best formula to ensure that we’ve summed up all values from B4 through B15?