Module 6 · Digital Workplace Skills & Documentation
Worksheet 6.4 — Workplace Spreadsheet Practice
Build a spreadsheet for a real or hypothetical materials list.
Name: ______________________________
Date: ______________________
Item, Quantity, Cost, Difference
- List — Item, quantity needed, quantity available.
- Calculate — Difference and total projected cost.
- Act — Identify shortage and needed action.
Sample Materials Tracker
- Item: Baseboard trim; needed 40ft, available 28ft
- Shortage cost: 12 ft short at $2/ft = $24
- Action needed: Order 12 more feet today