Averaging stock prizes

You can complete this exercise on DataCamp using in-browser Excel or locally on your own computer if you have Excel installed (and Copilot where the course uses it).

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.