Excel Formulas and Functions Quiz

Which of the following formulas correctly adds the values in cells A1 and B1?

• `=A1+B1`

• `=SUM(A1:B1)`

• `=ADD(A1, B1)`

• `=A1*B1`

What function would you use to find the average of the numbers in cells C1 through C5?

• `=SUM(C1:C5)`

• `=AVERAGE(C1:C5)`

• `=MEDIAN(C1:C5)`

• `=COUNT(C1:C5)`

How would you format a cell to display numbers as currency in Excel?

• Use the "Number" format

• Use the "Currency" format

• Use the "Text" format

• Use the "Percentage" format

Which of the following is an example of an absolute cell reference?

• `A1`

• `A$1`

• `$A1`

What is the result of the formula `=B1*2` if B1 contains the value 5?

• 5

• 10

• 15

• 20

Which function would you use to find the largest number in a range of cells?

• `=MIN(range)`

• `=MAX(range)`

• `=LARGE(range)`

• `=SUM(range)`

How can you apply a conditional format to highlight cells greater than 100?

• Use the "Data Validation" tool

• Use "Conditional Formatting" with a rule "Greater than 100"

• Use "Find and Replace"

• Use "Sort and Filter"

What is the difference between relative and absolute cell references?

• Relative references change when copied; absolute references do not.

• Absolute references change when copied; relative references do not.

• Both change when copied.

• Neither change when copied.

Which formula will correctly calculate the sum of cells A1, A2, and A3?

• `=A1+A2+A3`

• `=SUM(A1:A3)`

• `=ADD(A1:A3)`

• `=TOTAL(A1:A3)`

If you want to ensure a cell always refers to cell D5, which reference would you use?

• `D5`

• `D$5`

• `$D5`