Review the Workbook in the Order It Was Built
Imagine a fictional lending desk joining an equipment list with a weekly checkout export. AI suggests a merge and a formula that flags long loans. Before handing the workbook to another team, check that the field definitions, merged rows, and calculations agree with their sources.
Work on a copy using approved sample data. Keep the original exports unchanged so you can explain any difference.
1. Confirm What Each Field Means
Use the schema for the exact export version. Write down the units, identifier format, and meaning of blank values. Do not use example rows to guess a definition the source does not provide.
Try it: Check an AI data dictionary against a schema.
2. Account for the Rows in the Merge
Check which keys should match and whether repeated keys are expected. Investigate examples of extra, conflicting, or unmatched rows. A matching total row count is not enough if one record was dropped and another was duplicated.
Try it: Check an AI CSV merge against original records.
3. Test the Formula on Known Rows
Write down expected results for a normal value, a blank, and a value exactly at the threshold. Verify them in the intended spreadsheet app. Check a later row too, where a reference might have shifted after filling down.
Try it: Check an AI spreadsheet formula before copying it.
Example: Two IDs That Look Alike
The equipment list says IDs are five-character text. The source contains 00412, but the merged sheet shows 412. A formula can return the expected flag on that row and still be attached to the wrong record. Hold the handoff. Rebuild the merge from the preserved source, verify the affected keys and rows, then rerun the formula checks.
Leave Evidence for the Next Refresh
Record the export version, the cases you tried, and any exceptions still open. On the next refresh, start with the last exception. If the schema, merge rule, or formula changed, rerun the affected checks in order. Keep private rows or attachments in an approved location, not in a shared copy of the checklist.
Download the spreadsheet handoff checklist (.txt)
The practice packs use separate fictional datasets. Start with one check or return to the practice packs to choose another.