DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
An absolute cell address is created
|
|
|
Cell address will change when it is copied to another cell
|
|
|
The sheet tab is changed
|
|
|
The status bar does not display the cell address
|
Detailed explanation-1: -Answer» A. An absolute cell address is created.
Detailed explanation-2: -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 dollar sign ($) is the symbol found on the same key as the number four (4) key on United States QWERTY keyboard. The dollar sign is often used to represent a U.S. currency value, e.g., $10.00 for ten dollars.
Detailed explanation-4: -In an Excel formula, a dollar sign ($) is used to create an absolute reference. When a cell reference is absolute, it means that it will not change when the formula is copied or moved to a different location within the worksheet. The dollar sign is typically used to fix the column or row of a cell reference, or both.
Detailed explanation-5: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.