Reason about cells, fills and formats
Build on your first workbook with calculation order, typed cells and a complete service schedule.
Start with cell addresses and ordinary formulas. 23 original steps connect applied cell changes, source predictions, independent recalculations, native history, workbook movement, boundary navigation, clock values, selection summaries, linked missing-label repair and actual formula auditing. Continue after the first-workbook course. Move freely between steps; save only a checked current attempt.
0 of 23 historical passing attempts saved on this device.
Step 1
Explain calculation order →
Multiplication runs before addition. Parentheses group an addition first; changing display precision does not change this order.
Before this step: Enter formulas and find their source cells.
Step 2
Separate data type from position →
General cells normally put numbers on the right and text on the left. Manual alignment can reverse those clues without converting data.
Before this step: Distinguish a number from a literal numeric-looking label.
Step 3
Fit several columns together →
Automatic width measures each selected column separately. It changes the layout, while values and formulas remain intact.
Before this step: Enter text and change a selected column width.
Step 4
Build a numeric and calendar schedule →
Extend numeric seeds and monthly dates, and bulk-enter only the regular-rate areas. Explicit monthly filling preserves the original day anchor.
Before this step: Use typed entry and relative formulas.
Step 5
Extend padded labels and ordered stages →
A text-number fill preserves the label and minimum digit width. An ordered list wraps at its boundaries; neither is automatic pattern inference.
Before this step: Complete the numeric schedule in the previous step, or rebuild it using the instructions below.
Step 6
Format separated areas with one action →
One selected-area format operation should affect every selected cell and leave the skipped premium row intact. The operation has one native Undo step.
Before this step: Complete both schedule fill steps.
Step 7
Move a linked report into a new workbook →
A move creates live destination worksheets before removing the source bundle. A newly empty destination has no namesake rates to reuse; its transferred dependency still needs to travel.
Before this step: Use cross-sheet formulas, typed entries and native Undo.
Step 8
Center a heading without merging cells →
Center across selection positions a heading over following empty cells while keeping their addresses independent. A merged heading changes the grid structure. An occupied cell starts a new span.
Before this step: Select a rectangle, enter a heading and inspect alignment.
Step 9
Navigate a divided inventory →
A data-boundary jump follows the current column. It stops at the end of a filled block, then crosses a blank gap to the next occupied cell. A stored zero remains data.
Before this step: Select a starting cell and enter source-based formulas.
Step 10
Select across a blank separator →
Extending keeps the starting cell as an anchor. Repeating the operation can include a blank row and a second block. COUNT counts numeric values while ROWS counts physical rows.
Before this step: Complete the linked inventory report; navigation and selection are different operations.
Step 11
Record time without creating a live formula →
A fixed clock entry stores the local browser date or time at capture. TODAY and NOW are formulas that sample the clock when calculation runs. A whole serial is the day; its fraction is the clock time.
Before this step: Select ordinary cells and distinguish numeric storage from a date/time display.
Step 12
Inspect a selection before writing a formula →
The live status bar summarizes the actual selected cells without writing a formula. Nonempty count includes labels; numerical count includes zero. Selected blank cells increase the physical selection size but not either count.
Before this step: Select a range and distinguish numbers, labels and blank cells.
Step 13
Fill missing labels without replacing data →
Fill only genuinely blank cells. Each linked result refers to the preceding selected row; zero, false and a formula returning empty text remain occupied. A leading blank has no seed inside the selection and stays blank.
Before this step: Select a range and distinguish stored values from formulas.
Step 14
Find formulas behind different results →
A formula is identified by its stored expression. Its result may be a number, empty text, a logical value or an error. Text that begins with = is still text when entered as Text. ISFORMULA checks the referenced cell, not its displayed result.
Before this step: Select real cells, enter formulas and distinguish stored text from calculated results.
Step 15
Build formulas and inspect function inputs →
A complete formula may use operators, named calls or nested calls. Arguments are ordered inputs; they can be references, expressions or literals. A comma inside quoted text or an array stays inside that argument. An absent optional LEFT count uses one character.
Before this step: Enter formulas, select real source cells and distinguish stored values from displayed results.
Step 16
Remove decoration without erasing meaning →
No Fill and No Border remove selected layers. Clear Formats also removes number formats and fonts. Neither operation should replace your underlying calculations.
Before this step: Read the actual formula bar and distinguish stored data from its appearance.
Step 17
Rebuild readable borders over a solid fill →
A solid cell fill can hide ordinary gridlines. Explicit contrasting borders define the report: thin internal lines, a medium outer frame and a double total underline. None of these changes should alter the report calculation.
Before this step: Selectively remove fill/borders and recover that change with Undo and Redo.
Step 18
Move cells and inspect their dependents →
Moving a formula alone retains its source references. Moving its referenced input cells changes the references in dependent formulas. A native border move clears its source and carries cell formats; Undo should recover the complete operation.
Before this step: Select a finite range and read the actual formula bar.
Step 19
Copy a complete report by dragging →
This lab’s explicit Copy mode routes a native border gesture through an internal copy buffer, without changing the OS clipboard. Relative formulas follow the copied rows; the absolute fee stays shared. Original and copied numeric inputs then work independently.
Before this step: Distinguish a selection border from its corner fill handle.
Step 20
Format selected cells from the keyboard →
A focused formatting shortcut opens settings for selected cells without navigating command tabs. The general shortcut recalls the last category; the Font shortcut opens Font directly. Preview and Cancel leave the worksheet unchanged. Apply changes the captured cell formats in one native history operation.
Before this step: Select a real worksheet range and distinguish stored numbers from their display.
Step 21
Choose commands for the selected object →
General commands remain available across the worksheet. Table commands depend on a selection inside a real Table. Pinning and collapsing change command access; they do not apply a worksheet edit or replace its history.
Before this step: Select actual worksheet cells, inspect formulas and recover a worksheet operation with Undo and Redo.
Step 22
Return to a kept workbook without losing its contents →
Current Microsoft 365 Favorites and earlier Pinned views keep access to a workbook. Removing that membership does not delete its contents. This local exercise retains original workbook contents in page memory and has its own explicit controls.
Before this step: Inspect the actual worksheet values and formulas. Distinguish file access from editing a cell.
Step 23
Draw the actual worksheet border you intend →
Draw Border traces cell edges; Draw Border Grid creates internal and outside edges across a gesture rectangle. Erasing one shared physical line must preserve other borders and the actual worksheet contents.
Before this step: Inspect a real worksheet cell and its unrounded formula. Distinguish gridlines from stored borders.
Saved records contain unit, version, check/scenario counts and date only. They do not restore worksheet data or certify mastery. Native Excel rendering, recalculation and edit/save require separate checks.