Range
What is Range?
Definition
A range is a collection of cells in a spreadsheet that are selected and treated as a single unit. Ranges are commonly used when performing calculations, applying formatting, creating charts, or working with groups of related data. This makes it possible to work with multiple cells at once instead of repeating the same action on each cell individually.
Frayer Model Overview
Characteristics
Consists of two or more cells
Cells are usually adjacent and rectangular
Identified by the addresses of its first and last cells
Used as input for formulas and functions
Acts as one selection for actions or calculations
Examples
A range of cells containing monthly expenses
A range selected to calculate a total or average
A range used as the source for a chart
A range of grades used in a function
Selecting a block of cells to apply formatting
Non-Examples
A single cell
An entire worksheet
A chart created from data
A text paragraph in Word
A file or folder