FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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-2: -To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2!A1.

Detailed explanation-3: -A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet. A cell reference can be used as a variable in a formula.

Detailed explanation-4: -A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1. A range is a group of two or more cells in a worksheet.

Detailed explanation-5: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.