1. 1

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

  2. 2

    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?

  3. 3

    A5 shows a value of 1234.56. Which of the following methods would you use to round the value 1235?