Excel Quiz Questions

What does 'Sort Ascending' do in Excel?

• Sorts from Z to A or largest to smallest

• Sorts from smallest to largest or A to Z

• Sorts based on header values only

When sorting a range with multiple columns, what must you do?

• Select only the column you want to sort

• Select the entire range to keep data aligned

• Click sort on the header cell only

What happens if you sort only one column in a multi-column range?

• It organizes data perfectly

• It maintains all relationships

• It breaks the relationship between columns

What does the Filter function do in Excel?

• Deletes rows permanently

• Hides rows that don't match criteria

• Removes formatting from a table

Where should filters be applied in a dataset?

• On any random row

• Below the data row

• On the top row (header row)

How do filters differ from table formatting?

• Filters delete duplicates

• Filters can be turned on/off without changing structure

• Filters remove all hidden rows

What is a key benefit of converting a range to a table in Excel?

• It removes all filters

• It creates fixed structure and shared formatting

• It hides all empty cells

Which tab appears when you click inside a table?

• Layout Tab

• Insert Tab

• Table Design Tab

What does resizing a table affect?

• Only formatting, not structure

• The range, formatting, and formulas

• Only the width of the columns

What happens when you delete the header row before applying a filter?

• Excel disables filtering

• The filter replaces the first row as the header

• Excel ignores the filter command