What is a range in Microsoft Excel?

In Microsoft Excel, a range refers to a collection of two or more cells. It is typically represented by the cell address of the top-left cell, followed by a colon, and then the cell address of the bottom-right cell. Therefore, B1:B2 correctly denotes a range encompassing cells B1 and B2.

• "A1" (A) represents a single cell, not a range.
• "#REF!" (B) is an error message indicating an invalid cell reference.
• "100" (D) is a numerical value, not a cell reference or a range. Understanding ranges is fundamental for performing calculations and applying formatting to multiple cells simultaneously.