Episode 4.7
MASTERING THE SPREADSHEET
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.7
✍️ Episode 4.7 Topic Notes
📌 The Classic Multiplication Matrix Table ($10 \times 10$)
- Put numbers 1 to 10 in cells
A2:A11(vertical factors). - Put numbers 1 to 10 in cells
B1:K1(horizontal factors). - Enter the formula in cell
B2:=$A2 * B$1. - Dragging this single formula across the entire $10 \times 10$ grid calculates all 100 products flawlessly!