Excel Functions Quiz

What is the result of =10+5?

• 105

• 15

• 5

• Error

Which formula subtracts cell B2 from A2?

• =A2+B2

• =B2-A2

• =A2-B2

• =A2*B2

What does =8*3 return?

• 24

• 11

• 83

• 5

The formula =20/4 returns:

• 5

• 4

• 16

• 24

Which operator is used for multiplication?

• x

• /

• *

• +

What is the result of =25-10?

• 35

• 15

• 10

• 20

What is the result of =4+9*2?

• 17

• 26

• 22

• 24

What is =6*6-12?

• 24

• 36

• 48

• 60

Which formula divides A1 by B1?

• =A1+B1

• =A1/B1

• =A1-B1

• =A1*B1

What happens when you type =12/0?

• 12

• 0

• #DIV/0!

• #VALUE!