Quiz

What does the "Remove Duplicates" feature in Excel do?

• Deletes all rows with the same values in every column

• Removes repeated values from a selected range or table

• Sorts the data and highlights duplicates

• Only removes duplicates if conditional formatting is applied

What does the TEXT function do in Excel?

• Converts numbers to formatted text

• Extracts text from formulas

• Combines multiple strings

• Formats fonts in text

Which function is used to combine the contents of two cells (e.g., A1 and B1) in older versions of Excel?

• MERGE()

• CONCATENATE(A1, B1)

• TEXTJOIN(A1)

• JOIN(A1, B1)

Which function would you use to replace all occurrences of "cat" with "dog" in cell A1?

• =REPLACE(A1, "cat", "dog")

• =SWITCH(A1, "cat", "dog")

• =SUBSTITUTE(A1, "cat", "dog")

• =SUBSTITUTE(A1, "dog", "cat")

What is the main purpose of Data Validation in Excel?

• To validate formulas

• To remove incorrect entries

• To restrict user input based on specific criteria

• To compare worksheet data

Which Data Validation setting allows users to choose from a predefined list of values?

• Whole Number

• List

• Custom

• Text Length

What does the "Filter" feature in Excel allow you to do?

• Merge cells

• Display rows matching specific conditions

• Validate data formats

• Highlight text

When using filters, what happens to the rows that do not meet the criteria?

• They are deleted

• They are moved to another sheet

• They are hidden from view

• They are converted to formulas

Applying a filter in Excel permanently deletes the rows that do not meet the filter criteria.

• True

• False

What does the LEFT(text, num_chars) function do?

• Extracts characters from the right of the string

• Extracts characters from the beginning of the string

• Changes the text to uppercase

• Reverses the text