In
this demo in the Excel 2016 from Scratch series, Peter Kalmstrom
shows two different ways to calculate the maximum, minimum
and average values from cells with numbers. As an example
Peter uses the price and mileage of cars of different brands
and from different years.
Peter shows two methods, one where he selects the cell range
for each formula and one where he instead gives a name to
the cell range and uses it in the formula.