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.