Quiz - Sum and Subtract

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 entere

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)