Explain the following term cell and active cell and range
Answers
Explanation:
The location of a cell on a worksheet is given by its column letter and its row number (e.g. "A1"). This is often referred to as the Cell Address.
All the cells on a worksheet are separated by grey lines, known as gridlines and a group of adjacent cells is known as a Range of cells.
There are three types of cell reference operator that can be used to identify cells and ranges. The colon, comma and the space.
Colon ( : ) - This is used to define a range of cells (e.g. "A1:D4"). A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon.
Comma ( , ) - This is used to define non adjacent cells (e.g. "A1", "B2"). The comma is also known as the union operator.
Space ( ) - This is used to combine the intersection of two blocks of cells (e.g. "A1:D4 B2:C3"). When you use this operator the two blocks of cells must overlap. If not then an error message will appear. The space is also known as the intersection operator.
Multiple cell ranges are commonly known as non adjacent or non contiguous ranges. These are ranges of cells that are not in a nice rectangular block.
Answer:
here is the answer for above question
