Excel Functions and Features Quiz

Which of the following functions returns the largest number in a range of cells?

• MIN

• MAX

• SUM

• AVERAGE

What does the AutoFill feature do in Excel?

• Automatically corrects spelling errors

• Creates formulas based on sample data

• Fills a series of values based on a pattern

• Automatically adjusts cell formats

Which function would you use to count only the cells that meet a specific criterion?

• SUM

• AVERAGEIF

• COUNTIF

• MAXIF

Flash Fill is used to:

• Apply conditional formatting

• Automatically fill cells based on detected patterns

• Sort and filter data

• Add data validation rules

Which of the following is a logical function that checks if multiple conditions are true?

• OR

• AND

• NOT

• IF

In Excel, the VLOOKUP function:

• Searches for a value in a row

• Searches for a value in a column

• Searches for a value in a table and returns a match from the same column

• Creates an array

What happens if you apply data validation to a cell in Excel?

• It formats the cell with a specific style

• It restricts the data that can be entered

• It highlights data based on conditions

• It creates an error message in the cell

Which of these functions can display a list of unique values?

• SORT

• UNIQUE

• FILTER

• TEXTJOIN

When would you use the CONCATENATE or TEXTJOIN functions?

• To sum numbers across cells

• To join text from multiple cells

• To find unique values

• To format dates

The IFERROR function is useful for:

• Adding formatting to errors

• Handling errors in formulas

• Displaying the last cell value

• Sorting data in a range