1
00:00:00,080 --> 00:00:04,052
A due-date sort should reorder complete orders, not just the dates.

2
00:00:04,052 --> 00:00:07,693
If only one column moves, an order can appear to belong

3
00:00:07,693 --> 00:00:09,679
to the wrong customer or amount.

4
00:00:09,679 --> 00:00:13,651
We will use a four-row fictional list, sort by due date,

5
00:00:13,651 --> 00:00:17,622
and verify an ID-to-customer-to-amount relationship after the move.

6
00:00:17,622 --> 00:00:21,925
This gives you a concrete integrity test beyond a visually sorted date column.

7
00:00:22,525 --> 00:00:24,781
The practice CSV contains four orders.

8
00:00:24,781 --> 00:00:30,045
SO-031 belongs to Avery for one hundred twenty-five, SO-032 to Blair

9
00:00:30,045 --> 00:00:36,060
for eighty, SO-033 to Casey for forty, and SO-034 to Drew for fifty-five.

10
00:00:36,060 --> 00:00:38,316
These relationships are the answer key.

11
00:00:38,316 --> 00:00:42,452
Import a copy into Excel and keep the source file untouched

12
00:00:42,452 --> 00:00:46,963
so you can recover if a partial-column sort changes a pairing.

13
00:00:47,563 --> 00:00:51,291
Click inside the table or select all four columns and the

14
00:00:51,291 --> 00:00:54,001
four data rows, including a single header row.

15
00:00:54,001 --> 00:00:58,067
In Excel, use the Data tab's Sort command, choose Due date

16
00:00:58,067 --> 00:01:01,117
as the sort key, and order oldest to newest.

17
00:01:01,117 --> 00:01:04,844
A table object can help keep columns together, but the essential

18
00:01:04,844 --> 00:01:09,249
rule is that the sort range contains every field belonging to each record.

19
00:01:09,849 --> 00:01:14,035
If you had selected only date cells, Excel may ask whether

20
00:01:14,035 --> 00:01:15,557
to expand the selection.

21
00:01:15,557 --> 00:01:19,743
For this exercise, choose Expand the selection so IDs, customers, dates,

22
00:01:19,743 --> 00:01:21,265
and amounts move together.

23
00:01:21,265 --> 00:01:25,450
If the prompt does not appear, cancel and explicitly select the

24
00:01:25,450 --> 00:01:27,353
entire data block before sorting.

25
00:01:27,353 --> 00:01:31,158
Do not choose Continue with the current selection unless you

26
00:01:31,158 --> 00:01:33,441
intentionally want to detach the dates.

27
00:01:34,041 --> 00:01:39,312
The earliest date belongs to SO-032 and Blair, followed by SO-034

28
00:01:39,312 --> 00:01:43,773
and Drew, SO-031 and Avery, then SO-033 and Casey.

29
00:01:43,773 --> 00:01:46,611
Compare the amounts along with the IDs.

30
00:01:46,611 --> 00:01:49,855
Seeing October fifteenth, sixteenth, eighteenth, and twentieth in

31
00:01:49,855 --> 00:01:52,693
ascending order is necessary, but not enough.

32
00:01:52,693 --> 00:01:57,559
The customer and amount must still travel with their original order ID.

33
00:01:58,159 --> 00:02:01,655
If the order-to-customer relationships have changed, use Undo

34
00:02:01,655 --> 00:02:04,802
immediately while the sort remains the most recent action.

35
00:02:04,802 --> 00:02:08,648
If you have already made more changes, compare each row to

36
00:02:08,648 --> 00:02:12,144
the untouched source CSV or restore a previous workbook copy.

37
00:02:12,144 --> 00:02:16,689
Do not guess which amount belongs to which order from the sorted dates.

38
00:02:16,689 --> 00:02:21,583
The safe outcome is confirmed by keys, not by how tidy the sheet looks.

39
00:02:22,183 --> 00:02:26,325
The exercise passes when the dates are ascending and the four

40
00:02:26,325 --> 00:02:29,713
order relationships remain exactly as in the original file.

41
00:02:29,713 --> 00:02:32,725
The answer check lists the complete expected sequence.

42
00:02:32,725 --> 00:02:36,866
On a real sheet, add a stable unique ID before sorting

43
00:02:36,866 --> 00:02:42,137
if one does not exist, and inspect hidden columns or rows as Microsoft advises.

44
00:02:42,137 --> 00:02:46,278
A clean date order alone cannot prove the records survived intact.