Microsoft Certified Application Specialist (MCAS)

Names that are provided to a range of cells are knows as named ranges. Named ranges are helpful in referencing a cell or the range in any part of an Excel worksheet. Descriptive names can be given to represent a cell, a range, a formula etc.