Naming specific cell ranges within your data can be extremely useful. If there is a particular column or row of information that you will use regularly for formulas or calculations throughout your workbook, it can definitely be easier and save time if you have given that particular range an easy reference to use.

We've reverted our dataset to before we applied our table styles, we'll now add some names to some important ranges within our data.

How to do this exercise locally

Instructions

$1$

$2$

$3$

$4$

$5$

$6$

What is the average Order Line price across the entire dataset? Round to $2$ decimal places.