Protect record meaning before changing the table.
Review whole-record sorting, combined filtering, text identifiers, numeric types, ASCII trimming and duplicate comparison columns.
Your count is the number of matching keys among six selected questions in this edition. It is not an Excel level, job threshold, certificate or percentile. Every answer, explanation and complete guide is available at every count.
Six checks on data representation and rows
These tasks ask what happens to a small stated table, rather than asking you to upload or modify a real file. They cover keeping names paired with quantities during a sort, requiring two filter conditions together, preserving leading zeros in a text identifier, distinguishing numeric text from a number, trimming ordinary ASCII spaces and removing exact duplicate row pairs. Each answer depends on the operation and comparison columns stated in the question.
Move complete records when sorting
Imagine an unscored list with Vale/7, Sora/2 and Neri/5. Sorting the complete two-column table by quantity ascending should produce Sora/2, Neri/5, Vale/7. Sorting only the quantity cells while leaving names in place destroys those associations. On a disposable example, mark a temporary invented record ID and verify every pairing after sorting. A neat ascending numeric column is not enough evidence that the table’s meaning has survived.
Check every condition on the same record
For a requirement such as Colour=Gold AND Qty>=6, a record must satisfy both tests. A Gold row with quantity four fails the numeric condition, and a Blue row with quantity eight fails the colour condition. Filtering changes which rows are visible under the criterion; it does not make excluded records cease to exist. State whether your operation filters, sorts or deletes before interpreting the result, since those operations preserve different aspects of the source.
Store identifiers as text when the zeros matter
An identifier such as 0073 is a sequence of characters, not necessarily a quantity for arithmetic. For the stated task, format the destination as Text before entering the identifier so its leading zeros are retained as text. A numeric display mask can show zeros without turning the stored value into that text identifier. Similarly, a cell that looks like 12 may still hold text; SUM on a referenced range does not treat every number-looking display as numeric data.
Name the characters and duplicate keys precisely
TRIM handles ordinary ASCII spaces, removing outer spaces and reducing repeated inner ones. It does not remove every Unicode whitespace character, so first identify what is present. For duplicate removal, the selected comparison columns define a duplicate: an identical code with a different quantity remains distinct when both columns are compared. Removal changes the data. Practise on a disposable copy, keep a row count and inspect the comparison columns before applying it to any useful table.
Change one assumption and predict again
Build five invented rows containing one exact duplicate, one repeated code with a different quantity and one identifier with leading zeros. Write down what should remain when comparing both columns, then what would remain when comparing the code alone. Do not perform the second deletion on your only copy of the first result. Use a fresh disposable copy for each experiment. This exposes why an operation can be technically successful while answering the wrong data-cleaning question.
A tidy table is not proof of correctness
The six-item count does not audit provenance, verify a dataset, assess privacy compliance or certify job readiness. A perfect selection set cannot show whether you would notice an unstated problem in a large workbook. Use each complete explanation to identify an assumption worth checking in a new exercise. No private file is needed here, no data is uploaded for this practice, and no population norm or professional designation is derived from your answers.