FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.

Detailed explanation-2: -A range reference is represented by the address of the upper left cell and the lower right cell separated with a colon. For example, the range A1:C2 includes 6 cells from A1 through C2.

Detailed explanation-3: -We can specify a range by writing the starting cell address followed by the ending cell address; both separated by a colon (:).

Detailed explanation-4: -The cell addresses are represented by row number and column name. The cell address for first row and first column is A1. This cell address for first row and last column is represented by first row and the last column. The first row is 1 and the last column is XFD, so the cell address will be XFD1.

Detailed explanation-5: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.