Core navigation & data handling — flashcards
One card per lesson — 4 in this module. Recall the key points, then check. 4 cards. Click a card to flip, or use the arrow keys and space bar.
Cell references and the $ sign — what are the key points?
$ locks whatever follows it; F4 cycles the four states · Mixed references let one formula fill a whole grid · Tables (Ctrl+T) give structured references that auto-expand Read the lesson
Validation and workbook quality — what are the key points?
Validation is bypassed by paste; use Circle Invalid Data to audit · Unlock editable cells first, then protect the sheet · Evaluate Formula steps through a calculation to find the failure point Read the lesson
Sorting and filtering — what are the key points?
Ctrl+T converts a range to a Table that expands automatically · Structured references beat cell ranges and survive new rows · Remove Duplicates deletes silently — inspect first Read the lesson
Formatting and custom number formats — what are the key points?
Formatting changes display only — ROUND changes the value · A trailing comma in a format code divides the display by a thousand · Left-aligned numbers that will not sum are text Read the lesson