FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -ACTIVE CELL. In an Excel worksheet, each small rectangle or box is known as a cell. The active cell is the selected cell in which data is entered when you begin typing.

Detailed explanation-2: -Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.

Detailed explanation-3: -Cells are the boxes you see in the grid of an Excel worksheet, like this one. Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.

Detailed explanation-4: -The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box.

Detailed explanation-5: -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.