Lab 4
Spreadsheets — Formulas and Formatting
IT 231: IT and Applications (BBA) · 1 lab hour
Learning objectives
- Use SUM, AVERAGE, and IF
- Format currency and freeze panes
- Use an absolute reference for a tax rate
Task 1
Build Sales sheet with Quantity, Unit Price, Revenue.
Task 2
Totals with SUM/AVERAGE; Status with IF.
Task 3
Currency format; freeze header; tax via absolute reference.
Viva prompts
- Relative vs absolute reference?
- What must you still check by eye with SUM?
- Spreadsheet vs word-processor table?
- Why freeze panes?
End of Lab 4
Submit before you leave · ask questions now