Averaging stock prizes

In the last exercise, you've looked at Excel's summary data view to quickly get an idea of the average difference in open vs. close stock prizes for all selected rows.

In this exercise, you're going to calculate that average again, but now by fixing it into a designated cell on the worksheet. This would be useful when new data would be added; the calculated average would be updated automatically.

If you lost progress, close any open reports and load 1_3_creating_your_first_formula_solution.xlsx from the Workbooks folder on your local computer.