Using Names in Formulas

The Intermediate Guide to Excel focuses on References. The first lesson looked at Cell References: Relative and Absolute Cell References. The second lesson used the Cell References in a Formula. The lesson demonstrated formulas that modified and formatted Text, Date and Time. This third lesson will show how to select a RANGE of cells and use a Named Range in a Formula

 

Start the Program Microsoft Excel.

What Do You See? Is there a Title Bar that says Book1 - Microsoft Excel? Yes.

Is there a Home Ribbon with the Clipboard, Font, Alignment and Number Groups? Yes.

If your screen looks similar to the example on this page, then you are ready to get started.