Quiz

  1. 1
    Beginner

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

  2. 2
    Beginner

    Suppose cells B4:B15 contain data, and the formula =SUBTOTAL(9,B5:B8) returns the subtotal reported in B9. Which is the best formula to ensure all values from B4 through B15 are summed up?

  3. 3
    Beginner

    Suppose cell A5 contains the value 1234.56. Which formula or method rounds this value to 1235?