FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -In Microsoft Excel, a range is a block of two or more cells. 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-2: -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-3: -A range is identified by the cell references of the cells in the upper left and lower right corners of the range. These two references are separated by a colon ( : ) which tells Excel to include all the cells between these start and end points.

Detailed explanation-4: -You can reference a range of cells in a formula by inserting a colon (:) between two cell references. For example, you can add a range of values using the SUM() function. In this example, we show how you can sum an entire row or column of values, by specifying the range between two cell references.

Detailed explanation-5: -In the table, click the cell that you want to split. On the ribbon, select the Layout tab. Select Split Cells. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.