Excel Quiz

What symbol is used to start a formula in Excel?

• #

• =

• +

• @

Which function in Excel gives you the sum of a range of cells?

• SUM()

• ADD()

• TOTAL()

• PLUS()

How can you apply a single condition formatting rule to highlight cells greater than 50?

• Use the "Format Cells If" option

• Use the "Conditional Formatting" feature and select "Highlight Cell Rules" > "Greater Than"

• Use the "Data Analysis" tool

• Apply a custom formula

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

• MEAN()

• AVERAGE()

• MEDIAN()

• AVG()

What does the function =MAX(A1:A10) return?

• The minimum value in the range A1:A10

• The maximum value in the range A1:A10

• The average value in the range A1:A10

• The sum of all values in the range A1:A10

How can you quickly calculate the total of the numbers in cells A1 through A10?

• Type =SUM(A1:A10) in any cell

• Highlight cells A1 through A10 and look at the status bar

• Both A and B

• Use the "Quick Analysis" tool

Which of the following is not a logical function in Excel?

• IF

• AND

• OR

• FOR

To count the number of cells that contain numbers within a range, which function would you use?

• COUNT()

• COUNTIF()

• COUNTA()

• COUNTNUM()

What is the purpose of the VLOOKUP function in Excel?

• To vertically align text within cells

• To look up and retrieve data from a specific column in a table

• To verify the lookup value in the first row of a table

• To create a vertical lookup table

Which feature would you use to group rows or columns together and hide them?

• Conditional Formatting

• Data Analysis

• Group

• Merge & Center