Google Data Analytics Professional Certification Practice Test

The term "range" in a spreadsheet refers specifically to a collection of two or more cells. This concept is fundamental in spreadsheet programs such as Microsoft Excel or Google Sheets, where a range can be defined as a contiguous block of cells that can be referenced or manipulated together. For instance, when calculating sums, averages, or applying formatting, users often select multiple adjacent cells as a range to perform operations on all the cells within that selection at once. Using a range helps to simplify tasks such as data analysis, as you can quickly reference or apply functions to multiple cells without having to address them individually. Ranges can be defined by specifying the upper left cell and the lower right cell (for example, A1:B10 refers to all cells from A1 to B10), which allows for efficient data handling and makes it easier to visualize the data in those cells as a group.