Administration and Executive AssistantTier 140 minbeginner

Sorting Safely Without Breaking Links

Rearrange rows without breaking formulas that reference them.

What you will learn

• Sort by single and multiple columns
• Sort in a way that keeps related data together
• Use custom sort orders (weekdays, months)
• Understand what breaks when you sort

Excel skills

Sort dialog, custom sort, sort keys · Data Sorting

The task

Twelve suppliers, on-time delivery percentage and defect rate for each. I need a Rating column, on-time rate minus three times the defect rate, and then I need the table sorted by Rating from best to worst so I can see who we should be leaning on more.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free