DREW M Excel Basics Quiz for Grade 10

Which Excel formula would you use to add the values in cells A1 through A5?

• =AVERAGE(A1:A5)

• =SUM(A1:A5)

• =MIN(A1:A5)

• =MAX(A1:A5)

What is the result of the formula =AVERAGE(4, 8, 12)?

• 6

• 8

• 12

• 24

Which symbol is used in Excel to make a cell reference absolute?

• $

• #

• &

• %

If you want to sort a list of numbers in column B from smallest to largest, which sorting order should you choose?

• Descending

• Ascending

• Random

• Custom

Which function would you use to find the smallest value in a range of cells?

• =MAX()

• =MIN()

• =SUM()

• =AVERAGE()

Which Excel function would you use to calculate the average of the values in cells D1 to D10?

• =SUM(D1:D10)

• =AVERAGE(D1:D10)

• =MIN(D1:D10)

• =MAX(D1:D10)

• Relative reference

• Absolute reference

• Mixed reference

• No reference

If you want to find the highest value in the range D2:D10, which formula should you use?

• =MIN(D2:D10)

• =MAX(D2:D10)

• =SUM(D2:D10)

• =AVERAGE(D2:D10)

Which feature in Excel allows you to quickly highlight cells that are above a certain value using color?

• Data Validation

• Conditional Formatting

• Sorting

• Filtering

Which of the following can you change using the "Cell Styles" option in Excel?

• The cell's font color and fill color

• The cell's formula

• The cell's value only

• The worksheet name