Workspace.

Two data records, three fields each. P11's description is Mug, blue and its note is Label says "Fragile". P12's note has a line break between Top shelf and Keep upright. The header and multiline text occupy four physical lines in the supplied file.

Correct text import preserves all four IDs, with lengths 15, 16, 16, and 16. Stock remains numeric. In the separate known-damage control, 1234567890123456 and 1234567890123457 have both become 1234567890123450; formatting cannot distinguish or restore them.

List A contains seven data positions including a final empty value; List B has six. Under case-insensitive, space-preserving matching, only A has A101 and the leading-space A104, while only B has A104 and A105. A102 occurs twice in A and once in B. CaseA matches casea; blank entries are skipped.

With the header in row 1, the all-occurrences rule highlights worksheet rows 2, 4, 6, and 7 across A:B. The later-occurrences-only rule highlights rows 4 and 7. Incomplete pairs in rows 8 and 9 stay unhighlighted; they are not automatically valid records.

For September 1–30, 2026, an end condition before October 1 includes the final evening and totals 160 across all categories or 100 for Parts. A Parts calculation ending at September 30 midnight gives only 60. Timestamps must be numeric Excel date-times for the formulas.

Baseline SUM/9/109/count is 480/480/480/6. Filtering to North gives 480/230/230/4. In a separate exercise, turn filtering off, restore all rows, and manually hide worksheet row 5: expect 480/480/440/5. Do not combine the filter and manual-hide exercises.

September 4–11, 2026 has four eligible dates with Saturday/Sunday weekends and closures on September 7 and 10; excluding its start gives three. A Friday/Saturday weekend gives three. Keep weekend masks as seven-character text. The supplied guarded formulas label reversed dates Check date order; the closures are not a national holiday calendar.

In the Excel 1900 system, 46023 is January 1, 2026 at midnight; 46024.5 is January 2 at noon; 46025.25 is January 3 at 06:00; and 46024.75 is January 2 at 18:00. Time-only fractions 0, 0.25, 0.5, and 0.75 correspond to 0, 6, 12, and 18 hours. CSV control text does not store Excel cell formatting.

Default string-preserving JSON has two objects: {"id":"00123","quantity":"4","note":"Blue mug"} and {"id":"00456","quantity":"","note":""}. No property is omitted and no blank is changed to null. The guide's optional numeric-quantity mode is a separate exercise.

Three data records with headers id, note, status. IDs remain 00123, 00456, and 00789. The first note is Blue, "large" mug; the second note contains a literal tab between left and right and has an empty status; the third note contains a line break between line one and line two.