Copy expanding ranges into complete running totals
Enter one formula in G2 and use actual formula copying or filling to build G2:H7. G contains the cumulative Net amount and H the cumulative Signed units, including the current physical source row. Keep source order and include every signed value and numeric zero. All twelve outputs need individual native copies of your G2 seed; a one-anchor SCAN spill is a different learning exercise. Use finite whole-cent numeric measures from -1,000,000 through 1,000,000. Labels, including duplicates and literal punctuation, do not group or sort records.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G2 and use actual formula copying or filling to build G2:H7. G contains the cumulative Net amount and H the cumulative Signed units, including the current physical source row. Keep source order and include every signed value and numeric zero. All twelve outputs need individual native copies of your G2 seed; a one-anchor SCAN spill is a different learning exercise. Use finite whole-cent numeric measures from -1,000,000 through 1,000,000. Labels, including duplicates and literal punctuation, do not group or sort records.
No account. No upload. Just try it.