Objectives

  • Enter data, use SUM, AVERAGE, and a simple IF.
  • Format currency and create a column chart.

Theory: Application software, business information systems.

Tasks (55 minutes)

In a workbook named Surname_IT231_Lab4.xlsx:

  1. Sheet Sales: products A–E, columns Quantity, Unit Price, Revenue (=Quantity*UnitPrice).
  2. Totals row with SUM for Quantity and Revenue; AVERAGE of Unit Price.
  3. Status column: IF Revenue ≥ 10000 then "High" else "Normal".
  4. Format Revenue as currency (NPR or local).
  5. Insert a column chart of Product vs Revenue; title the chart.
  6. Freeze the header row.

Use at least five product rows with invented but realistic numbers.

Deliverable

The .xlsx file. Print the Sales sheet to PDF if required.

Viva

  1. What is a cell reference? Give a relative and an absolute example.
  2. Why is a chart useful for managers?
  3. What does SUM ignore that you still must check by eye?
  4. How is a spreadsheet different from a word-processor table?