Excel 365 in 30 Minutes – Named Ranges & Functions (Basics 5 of 10)

Topics covered include:

Describing the difference between a Relative and Absolute Reference.
Changing a cell reference to be absolute or mixed.
Identifying the purpose of a Name Range
Creating a Named Range from the Name Box on the ribbon and from the Create from Selection option
Listing the restrictions on the names of Named Ranges
Inserting a Named Range into a formula automatically
Inserting a Named Range into a formula from the Use in Formula and Paste Names options
Inserting a Named Range into a formula using AutoComplete
Defining a logical value and a logical function
Listing comparison operators
Writing a formula with the IF function