Microsoft Excel Quiz (25 Questions)

What formula adds the values in cells A1 and B1?

• =A1+B1

• =A1-B1

• =A1*B1

• =A1/B1

Which formula subtracts cell B2 from A2?

• =B2-A2

• =A2-B2

• =A2/B2

• =A2*B2

To multiply the contents of cells A3 and B3, which formula should you use?

• =A3+B3

• =A3-B3

• =A3*B3

• =A3/B3

Which formula divides A4 by B4?

• =A4-B4

• =A4/B4

• =A4*B4

• =A4+B4

What will the formula =A1+B1+C1 do?

• Multiply all three cells

• Add up the three cell values

• Subtract C1 from A1

• Divide A1 by C1

If A1 = 5 and B1 = 10, what does =A1*B1 return?

• 50

• 15

• 5

• 2

What is the correct formula to calculate half of cell A5's value?

• =A5/2

• =A5*2

• =A5+2

• =A5-2

Which operator is used for multiplication in Excel?

• ×

• X

• *

Which formula would correctly find the total of cells A1 through A5?

• =SUM(A1:A5)

• =TOTAL(A1:A5)

• =ADD(A1:A5)

• =COUNT(A1:A5)

What does the formula =10/2 display?

• 5

• 8

• 12

• 20