Sorting Excel

What is the primary purpose of sorting in Excel?

• To rearrange data based on specific criteria

• To delete unwanted data

• To change the color of cells

• To create new spreadsheets

Which of the following is NOT a way to sort data in Excel?

• Alphabetically (A-Z)

• By color

• Numerically (smallest to largest)

• By date (oldest to newest)

In Excel sorting terminology, what is a primary field?

• The last column to be sorted

• The first column Excel sorts by

• The column with the most data

• The column with text only

What happens when you have identical values in the primary sort field?

• Excel automatically deletes duplicate values

• The spreadsheet shows an error message

• The secondary sort field determines the order

• The values remain in their original order

If sorting grades from highest to lowest, which student would appear first?

• Student with 85%

• Student with 78%

• Student with 91%

• Student with 82%

What menu contains the sorting options in Excel?

• Insert

• Review

• Data or Home

• View

What is the difference between ascending and descending order?

• Ascending is alphabetical, descending is numerical

• Ascending is A-Z/smallest-largest, descending is Z-A/largest-smallest

• There is no difference

• Ascending is for text, descending is for numbers

What happens when you perform a primary sort by class and secondary sort by grade?

• Only the class column changes

• The grade column sorts first

• The data sorts by class first, then by grade within each class

• The data only sorts alphabetically

What is the result of sorting a list of names alphabetically?

• Names are displayed randomly

• Names are grouped by length

• Names are arranged from A to Z

• Names are arranged from Z to A