Excel Functions and Features Quiz

What does the 'Text to Columns' feature in Excel allow you to do?

• Merge cells together

• Split data in a cell based on a delimiter

• Apply conditional formatting to text

Which function is used to "Merge" multiple cell values into a single cell?

• COMBINE

• CONCATENATE

• TEXTTOCOLUMN

What is the primary purpose of 'Data Validation' in Excel?

• Automatically correct errors in data

• Limit the type of data entered into a cell

• Create pivot tables

What is the main function of VLOOKUP in Excel?

• Calculate values within a range

• Look up values in a vertical table array

• Perform arithmetic operations

How can you create a hyperlink to another cell or worksheet in Excel?

• Use the "Insert" tab or right-click to select "Hyperlink"

• Double-click a cell and then paste the link

• Type the URL directly into a cell

Which feature allows custom sorting based on specific criteria in Excel?

• A-Z Sort

• Custom Sort button

• Filter Button

How can you split the Excel window into two panes for easier navigation?

• Drag the split box at the top of the vertical scrollbar

• Use the "View" tab and select "Split"

• Press Ctrl + Shift + D

What does the filter function in Excel enable you to do?

• Highlight specific cells

• Eliminate specific criteria from the worksheet

• Hide rows that do not meet specified criteria

Which option in Excel allows you to quickly apply a consistent look to your workbook?

• Custom Formatting

• Theme Gallery

• Cell Coloring

How does converting a range of data into a table benefit in Excel?

• It automatically creates a chart

• It allows for easier data analysis and formatting

• It hides sensitive information