USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
$D2
|
|
|
$D$2
|
|
|
D$2
|
|
|
D2$
|
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.
Detailed explanation-2: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-3: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
Detailed explanation-4: -A reference to $A$1in a formula would remain unchanged when you copy it. $A1 would adjust the row number when copied but would still point to column A. And A$1 would keep the row number the same while adjusting the column reference.