Which is the best formula to add cells A1 and A4:A6 (A4 through A6) together?

Supporting image for quiz question

Answer 1

=SUM(A1,A4,A5,A6)

Answer 2

=SUM(A1:A6)

Answer 3

=SUM(A1,A4:A6)

Answer 4

Don’t know

Answer 5

=SUM(B4,B9:B15)

Answer 6

=SUBTOTAL(9,B4: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?