Practice: A Sales Report
Finish with a small report built on a sales list: revenue per row, totals by product, the best region and a lookup of one product's price. Every number is a formula, so changing a unit count updates the whole report.
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
Why compute revenue in a column of formulas instead of typing the numbers?
Your turn: write the code
In E8 show the total revenue of the list (the sum of E2:E4).
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.