Work through 75 source records in a 100-row worksheet. One genuinely blank row separates Receiving and Reserve. Column B includes a stored zero at B18; the blank B32 has a number format, which does not make it data.
Explain the current workbook
These checks read applied worksheet cells. Editor fields prepare a change; use the matching action button to put that change into the worksheet. A saved record describes a checked attempt on this device.
No current lesson check.
Loading your interactive spreadsheet…
Read the actual selection
B32 is blank; format General. A number format does not fill a blank cell.
Windows Excel uses Ctrl+Arrow and Ctrl+Shift+Arrow. Mac Excel uses Command+Arrow and Command+Shift+Arrow. In this browser lab, focus the pad first; the same controls call the native worksheet commands. Browser or operating-system interception can prevent a shortcut, so the buttons remain available. Microsoft shortcut reference
What to inspect
From B2, jump down to B31, across the separator to B33, then to B77. Jump up to B33.
From B44, select the current region. It is A33:D77, including all four fields.
From B2, extend down three times. Keep the B2 anchor: B2:B31, B2:B33, then B2:B77. The final selection includes 76 physical rows but only 75 numeric quantities.
Try other starts or edit a gap with the entry controls. New source contents change the boundary and invalidate the supplied exercise until restored.
Calculate what you selected
Author the five formulas below in column H. The lists stay separate; the complete range includes the blank row. ROWS explicitly uses the shown B2:B77 range.
Cell
Formula to author
Actual formula
Stored result
H2
=SUM(B2:B31)
Not entered
H3
=SUM(B33:B77)
Not entered
H4
=SUM(B2:B77)
Not entered
H5
=COUNT(B2:B77)
Not entered
H6
=ROWS(B2:B77)
Not entered
Observed native actions
Address entry alone does not add a native navigation observation. These operations must preserve source cells, formats and workbook history.
Sources and transient observations stay in this tab. Downloads include every original record and the current complete report. Workbook copies and native browser actions do not certify desktop key interception or native Excel edit/save.
