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

=SUBTOTAL(9,B4:B15)

Answer 6

=SUM(B4,B9:B15)

Answer 7

=SUM(B4:B15)

Answer 8

Don’t know

Answer 9

=ROUND(A5,-1)

Answer 10

=ROUND(A5,0)

Answer 11

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

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?