Advance Excel Function Quiz

Which function is used to find the highest value in a range?

• MIN()

• MAX()

• AVERAGE()

• COUNT()

What does the VLOOKUP function do?

• Vertically searches for a value in the first column of a range

• Horizontally searches for a value in a row

• Counts the number of values in a column

• Sorts data in ascending order

Which of the following is NOT a valid Excel data type?

• Number

• Text

• Boolean

• Image

What is the shortcut key to open the ‘Format Cells’ dialog box?

• Ctrl + F

• Ctrl + 1

• Ctrl + Shift + F

• Alt + Enter

What is the purpose of the IFERROR function?

• Returns 'Error' when a function fails

• Displays a custom message when an error occurs

• Shows the error code of a failed function

• Fixes errors automatically

Which function is used to combine text from multiple cells?

• CONCATENATE()

• CONCAT()

• JOIN()

• MERGE()

What does the $ symbol in a cell reference indicate?

• It makes the reference an absolute reference

• It converts the value to currency format

• It multiplies the value by 100

• It locks only the row reference

Which function is used to count only the numeric values in a range?

• COUNTA()

• COUNT()

• COUNTIF()

• SUM()

How can you remove duplicate values from a dataset in Excel?

• Using the 'Remove Duplicates' option in the Data tab

• Using the SORT function

• Using the UNIQUE function

• Both a and c

What does the INDEX function do?

• Returns the position of a value in a list

• Retrieves a value from a specified row and column in a range

• Sorts data alphabetically

• Finds duplicate values