Excel Formulas and Functions Quiz

What is the purpose of the SUM formula in Excel?

• To find the average of a range of cells

• To add up all the numbers in a range of cells

• To find the maximum value in a range of cells

• To subtract one number from another

How do you calculate the average of numbers in cells A1 to A5 in Excel?

• `=SUM(A1:A5)`

• `=AVERAGE(A1:A5)`

• `=MIN(A1:A5)`

• `=MAX(A1:A5)`

Which formula would you use to find the smallest number in a range of cells from B1 to B10?

• `=SUM(B1:B10)`

• `=AVERAGE(B1:B10)`

• `=MIN(B1:B10)`

• `=MAX(B1:B10)`

What is the result of the formula `=5 + 3` in Excel?

• 2

• 8

• 15

• 53

If cell C1 contains the number 10 and cell C2 contains the number 5, what is the result of `=C1 - C2`?

• 5

• 15

• 50

• 2

Which formula would you use to multiply the values in cells D1 and D2?

• `=D1 + D2`

• `=D1 - D2`

• `=D1 * D2`

• `=D1 / D2`

What is the result of the formula `=20 / 4` in Excel?

• 5

• 24

• 80

• 16

How do you find the largest number in a range of cells from E1 to E10?

• `=SUM(E1:E10)`

• `=AVERAGE(E1:E10)`

• `=MIN(E1:E10)`

• `=MAX(E1:E10)`

If cell F1 contains 8 and cell F2 contains 2, what is the result of `=F1 / F2`?

• 4

• 6

• 16

• 10

Which of the following is a correct way to use cell references in a formula?

• `=A1 + B1`

• `=1A + 1B`

• `=A1B1`

• `=AB1`