Formulas -> Function Library Summary This lesson demonstrated how to select a RANGE of cells and use a Named Range in a Formula.   This is just a small sample of the formulas that are available in Microsoft Excel. The purpose of this lesson is to show the advantages of using Defined Names to reference the data.   Very good. You get the cookie. Take two!