Which tab contains the **Sort** options in Excel?
Analysis & Theory
Sorting options like **Sort A to Z**, **Z to A**, and **Custom Sort** are found in the **Data tab**.
What does **Sort A to Z** do for text values?
A
Sorts in reverse alphabetical order
B
Sorts from smallest to largest
C
Sorts alphabetically from A to Z
Analysis & Theory
**Sort A to Z** organizes text in **ascending alphabetical** order.
What happens when you sort numbers **Z to A** in Excel?
A
They are sorted in ascending order
B
They are sorted from smallest to largest
C
They are sorted from largest to smallest
Analysis & Theory
**Z to A** for numbers means **largest to smallest**, which is descending order.
What is the purpose of **Custom Sort** in Excel?
C
It allows sorting by multiple columns or custom rules
D
It only works on filtered rows
Analysis & Theory
**Custom Sort** lets you sort by **multiple levels**, such as first by department, then by name.
Which option should you choose to sort data by **cell color or font color**?
Analysis & Theory
Use **Custom Sort** to sort by **cell color**, **font color**, or **icon**.
What does Excel ask if you try to sort a column next to unsorted data?
A
Do you want to remove blank rows?
B
Do you want to expand the selection?
C
Do you want to apply filter?
D
Do you want to merge the cells?
Analysis & Theory
Excel will prompt: **'Do you want to expand the selection?'** to include nearby data in the sort.
When sorting dates, what does A to Z do?
D
Groups all years together
Analysis & Theory
**A to Z** sorts dates from **oldest to newest** (ascending).
Which of the following cannot be sorted directly using Excel’s Sort options?
Analysis & Theory
You can sort **values**, but not **images or shapes** using Excel's built-in Sort tools.
What feature should you use before sorting to keep **column titles** from being sorted?
C
Check 'My data has headers'
Analysis & Theory
Checking **'My data has headers'** ensures the top row is treated as labels, not sorted values.
How do you sort data in Excel by more than one column (e.g., first by Age, then by Name)?
A
Use Sort A to Z multiple times
C
Use Custom Sort and add levels
Analysis & Theory
Use **Custom Sort**, then click **'Add Level'** to define multiple sorting criteria.