0 of 62
Projects·Project·Lesson 62 of 62Pro

A quarterly sales report

A closing project, using what the course has covered.

What you’ll do

The furniture shop from the Conditions section wants a short report for the quarter. You’ll add a month to every sale, then build the report beside it.

The steps

6 steps
  1. 1
    In G2, show the month number of the sale date in A2. Fill it down to G14.
  2. 2
    In J2, total the sales for the month in I2. Fill it down to J4.
  3. 3
    In J6, show which month had the most sales.
  4. 4
    In J7, work out how much March grew compared with January.
  5. 5
    Show the growth as a percent: select J7 and press Ctrl+Shift+5.
  6. 6
    In J8, total the sales for the whole quarter.

Project locked

Unlock the other 44 lessons for $49.99

Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.

Unlock for $49.99