Excel Formulas Quiz

What is the result of using the SUM function on the following set of numbers: 3, 5, and 7?

• 10

• 15

• 12

• 18

If you have the values 10 in cell A1 and 20 in cell A2, what formula should you use to subtract A1 from A2?

• =A2-A1

• =A1-A2

• =SUB(A2,A1)

• =MINUS(A2,A1)

How do you multiply the values in cells A1 (5) and A2 (4) using an Excel formula?

• =A1+A2

• =A1*A2

• =MULTIPLY(A1,A2)

• =A1^A2

What is the result of dividing 20 by 4 in Excel?

• 4

• 5

• 80

• 0.2

Using Excel, if you need to sum the numbers 8, 13, and 21 which are in cells A1, A2, and A3 respectively, what would be the correct formula?

• =SUM(A1:A3)

• =ADD(A1:A3)

• =A1+A2+A3

• Both A) and C) are correct

What formula will you use to subtract the number in cell B1 (15) from the number in cell A1 (30)?

• =A1-B1

• =SUBTRACT(A1,B1)

• =B1-A1

• =DIFF(A1,B1)

If you want to divide the number in cell A1 (50) by the number in cell B1 (10), which formula is correct?

• =A1/B1

• =DIVIDE(A1,B1)

• =A1\B1

• =A1 divided by B1

What is the result of multiplying the numbers 6, 3, and 2 in Excel?

• 36

• 11

• 18

• 12

To find the sum of the numbers 14, 19, and 27 in Excel, which formula would you use?

• =SUM(14, 19, 27)

• =14+19+27

• Both A) and B) are correct

• =ADD(14, 19, 27)

How would you correctly express a formula for subtracting the number in cell C1 (25) from the sum of numbers in cells A1 (40) and B1 (35)?

• =(A1+B1)-C1

• =SUM(A1+B1-C1)

• =A1+B1-C1

• Both A) and C) are correct