Excel Basics and Formatting Quiz

Which formula would you use in Excel to add the values in cells A1 and B1 together?

• =A1+B1

• =A1*B1

• =A1/B1

• =SUM(A1-B1)

What does the formula =AVERAGE(C1:C5) calculate?

• The sum of the values in cells C1 to C5

• The average of the values in cells C1 to C5

• The highest value in cells C1 to C5

• The lowest value in cells C1 to C5

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

• A1

• A$1

• $A1

If you want to highlight all cells in a column that are greater than 100 using conditional formatting, which rule should you use?

• Cell Value < 100

• Cell Value = 100

• Cell Value > 100

• Cell Value ≤ 100

What does the formula =SUM(D2:D6) do?

• Multiplies all values in D2 to D6

• Adds all values in D2 to D6

• Finds the average of D2 to D6

• Subtracts D6 from D2

Which formula would you use to find the smallest value in the range E1:E10?

• =MAX(E1:E10)

• =MIN(E1:E10)

• =SUM(E1:E10)

• =COUNT(E1:E10)

If you copy the formula =B1+C1 from cell D1 to D2, what will the new formula be?

• =B2+C2

• =B1+C1

• =C1+D1

• =B2+C1

Which of the following is a relative cell reference?

• A$1

• A1

• $A1

How can you apply a conditional formatting rule to highlight cells with text containing the word "Complete"?

• Use a rule: Cell Value > "Complete"

• Use a rule: Text that Contains "Complete"

• Use a rule: Cell Value = 0

• Use a rule: Duplicate Values

What does the formula =ROUND(3.14159, 2) return?

• 3.14

• 3.15

• 3.141

• 3.1