Excel Quiz

What symbol is used for multiplication in an Excel formula?

• x

• *

• /

• +

Which of the following formulas will correctly divide the value in C2 by 4?

• =C2/4

• =C2÷4

• =DIVIDE(C2,4)

• =C2-4

If cell A1 contains 6 and B1 contains 3, what will =A1*B1/B1 return?

• 6

• 3

• 2

• 1

What function can be used to multiply multiple values in Excel without using the * operator?

• SUM()

• PRODUCT()

• MULTIPLY()

• DIVIDE()

What will be the result of =PRODUCT(3,2,5)/5?

• 3

• 6

• 10

• 15

What happens if you enter =SUM(A1:A5) - A6 in Excel?

• It adds A1 to A5 and then subtracts A6

• It adds all six values

• It subtracts A1 and A5 from A6

• It results in an error

If cell A1 contains 50 and A2 contains 20, what will the formula =A1-A2 return?

• 30

• -30

• 70

• 50

Which of the following statements is true about the SUM() function?

• It can only add individual numbers, not cell ranges.

• It can add multiple numbers and cell ranges together.

• It can subtract numbers as well.

• It requires each number to be manually entered.

If cell B2 contains 200 and cell B3 contains 50, what will =B2-B3 return?

• 250

• 150

• -150

• 50

All of the functions are accepted except for one. Which one is it?

• =A1-A2

• =SUM(A1, A2)

• =A2+A1

• =ADD(A1+A2)