KwickClips Course Topics · 45 sec · free
What sets the step of a series?
Short answer. The first two values.
What does D3 hold after dragging =B2+C2 down?
=B3+C3.
Drag D2 down
| Cell | Formula |
|---|---|
| D2 | =B2+C2 |
| D3 | =B3+C3 |
| D4 | =B4+C4 |
Remember
| Two values set the step |
| Formulas follow the row |
You copied a formula, and it changed. Why? Drag D2 down. D2 adds row two. D3 adds row three. D4 adds row four. For a series, type two and four, then drag. Remember. Two values set the step. Formulas follow the row.
This clip is from the full lesson: Fill handle — number series and copying formulas — 6 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 9 Information Technology (402)
More KwickClips from this lesson
Voice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.