Lab 5
Spreadsheets — Charts and Business Sheets
IT 231: IT and Applications (BBA) · 1 lab hour
Learning objectives
- Create column and pie charts
- Use VLOOKUP/XLOOKUP
- Build a manager dashboard sheet
Task 1
PriceList + Orders with lookup for UnitPrice.
Task 2
Column chart and pie chart with titles.
Task 3
Dashboard: totals, average order value, short manager note.
Deliverable
Surname_IT231_Lab5.xlsx with both charts.
Viva prompts
- When is a pie chart a poor choice?
- VLOOKUP requirements?
- Why separate PriceList from Orders?
- What KPI would you add next?
End of Lab 5
Submit before you leave · ask questions now