Quiz

  1. 1
    Beginner

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

  2. 2
    Beginner

    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
    Beginner

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