The notation A1:G5 separated by a colon is called what?

The notation A1:G5 separated by a colon is called what?

• A. Range reference
• B. Cell reference
• C. Address range
• D. Reference range

Answer: (A)

When you see two cell coordinates separated by a colon, the notation designates a rectangular block of cells on the sheet. The first coordinate marks the top-left cell and the second marks the bottom-right, so every cell inside that rectangle is included. This whole block is called a range reference, because it references multiple cells at once. The colon acts as the range operator, letting formulas operate on the entire area, for example summing or averaging all cells in that range. It’s not a single cell reference—that would be just A1. While other terms might be heard, “range reference” is the standard way to describe this notation.

When you see two cell coordinates separated by a colon, the notation designates a rectangular block of cells on the sheet. The first coordinate marks the top-left cell and the second marks the bottom-right, so every cell inside that rectangle is included. This whole block is called a range reference, because it references multiple cells at once. The colon acts as the range operator, letting formulas operate on the entire area, for example summing or averaging all cells in that range. It’s not a single cell reference—that would be just A1. While other terms might be heard, “range reference” is the standard way to describe this notation.