Question

Which of the following formulas correctly anchors ONLY the row in cell A1?
* A1
* A$1
* $A1
* $A$1

Answer 1

Answer:A1

Explanation:

Answer 2

To anchor only the row in cell A1, we use the formula A$1.

Explanation: Microsoft Excel's anchoring feature enables you to rapidly copy formulas and paste them into the cells of your choice. Some formulas must be applied to particular cells, and anchoring enables you to apply the formula simultaneously to numerous cells. When you copy and apply a formula, it also makes sure that the cell reference stays the same and is in the same location. Because it's effective, simple to use, and compatible with standard cell references, it's frequently regarded as one of the most widely used alternatives in Excel.

To anchor a row: After clicking on a cell, hold down the "F4" key twice to only anchor a row. For instance, pressing "F4" twice after clicking on the "A1" cell transforms it to "A$1."

#SPJ2