Skip to content
Lesson 1/3

A sales report

Exercise 1 of 4

In F2, work out the day's revenue: quantity times price for every order, added up, in one formula.

About this lesson

One day of orders, four questions a manager would ask. Each answer combines functions you already know: multiplying and adding, conditions, lookups and lists.

In this lesson

  1. In F2, work out the day's revenue: quantity times price for every order, added up, in one formula.
  2. In F2, work out the revenue of the North orders only.
  3. In F2, show which product the biggest order (the largest quantity) was for.
  4. In F2, count how many different products were sold.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in F2 and press Enter to check.