Cells can be referenced in formulas by address or _____________ ranges.

• A. Named
• B. Named Ranges
• C. Range Names
• D. Address Ranges

Answer: (A)

Cells can be referenced in formulas by their address or by a named range. A named range is a label you assign to a single cell or a block of cells, and you can use that label in formulas just like you would use a cell address. This makes formulas easier to read and easier to maintain. For example, naming a range B2:B20 as Revenue lets you write =SUM(Revenue) instead of =SUM(B2:B20). Named ranges also help when the data moves or when you reorganize worksheets, since you can update the range in one place without rewriting every formula. This is why the sentence uses the word that forms the common term “named ranges.”