Episode 4.3
DATA ENTRY & AUTO FILL
Class 10 (X) • Unit 4: Digital Data Tabulation - Spreadsheet (MS Excel)
💡 Direct Stream: You can also watch directly on YouTube or via local server:
📺 Watch on YouTube.com
Episode code: 4.3
✍️ Episode 4.3 Topic Notes
📌 A. Number Series (Linear Growth)
- If you type
1in cell A1 and drag the Fill Handle, Excel simply copies1into every cell. - To generate a sequential sequence (
1, 2, 3, 4, 5...): - Arbitrary Steps:
5, 10$\rightarrow$ fills15, 20, 25, 30...
📌 B. Chronological Series (Built-in Calendar Lists)
Mon$\rightarrow$Tue, Wed, Thu, Fri, Sat, SunMonday$\rightarrow$Tuesday, Wednesday, Thursday...Jan$\rightarrow$Feb, Mar, Apr, May...January$\rightarrow$February, March, April...
📌 C. The AutoFill Options Smart Tag
- *Copy Cells* (duplicates original values).
- *Fill Series* (advances sequential increments).
- *Fill Formatting Only* (copies borders/colors without changing numbers).
- *Fill Without Formatting* (increments numbers while preserving target cell design).