Learn Excel EasyDaily One Lesson

Quiz › Formulas & Functions › Order of maths

Order of maths: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. What will this formula return?
    =10+5*2
    • A. 20
    • B. 30
    • C. 25
    • D. 17
    Show the answerA — 20. Excel multiplies first: 5*2 is 10, then 10+10 is 20.
  2. What will this formula return?
    =(10+5)*2
    • A. 20
    • B. 17
    • C. 25
    • D. 30
    Show the answerD — 30. Brackets go first: 10+5 is 15, then 15*2 is 30.
  3. What will this formula return?
    =2^3
    • A. 6
    • B. 9
    • C. 5
    • D. 8
    Show the answerD — 8. ^ means power: 2 x 2 x 2 is 8.
  4. What will this formula return?
    =10-2*3
    • A. 24
    • B. 4
    • C. 6
    • D. 16
    Show the answerB — 4. Multiply first: 2*3 is 6, then 10-6 is 4.
  5. A1 = 8 and B1 = 2. What will this formula return?
    =A1/B1+A1*B1
    • A. 32
    • B. 40
    • C. 20
    • D. 10
    Show the answerC — 20. 8/2 is 4 and 8*2 is 16. Then 4+16 is 20.

Want to learn this? Read the Formulas & Functions lessons →
← More Formulas & Functions topics · All quiz categories