Microsoft Word Practical 12 | Advanced Tables, Arithmetic, Formulas, Shading & Alignment #ict

Core Skills: Table Formulas, SUM, Multiplication, Cell Alignment CHAPTERS: 0:00 Practical 12 (15 minutes): Advanced Tables – Arithmetic, Formulas, Shading, Alignment 0:09 1. Open a new blank document. 0:38 2. Insert a table with 3 columns and 4 rows. 1:10 3. Create the following sales data table: Product Quantity Price ($) Laptop 2 750 Mouse 5 20 Keyboard 3 45 3:36 4. Add a new row at the bottom labeled Total Value. 4:57 5. In the Total Value row, use Table Formula (Table Layout - Formula) to calculate: =SUM(ABOVE) for the Price column. { SUM formula: Layout (Table Tools) then Formula then =SUM(ABOVE) or =SUM(LEFT).} 10:52 6. Add another column on the right called Total per Product and calculate Quantity * Price for each row (use formula: =B2*C2 etc.). { Multiplication: Formula then =B2*C2 (use cell references). Cell references: Columns = A, B, C... Rows = 1, 2, 3... Update formulas: Select cell then press F9 (update all with Ctrl+A then F9).} 15:31 7. Apply center alignment vertically and horizontally to all cells. { Center alignment: Select cells then Layout then Align Center.} 17:00 8. Shade the header row in dark blue with white text. { Shading header: Select row then Table Design then Shading then Dark Blue then White font.} 18:36 9. Save as Practical 12 YourName.docx NB: Formulas do NOT auto-update like Excel; use F9 to refresh. #computereducation