FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What happens when dollar sign ($) are entered in a cell address? ($B$2:$B$10)
A
An absolute cell address is created
B
Cell address will change when it is copied to another cell
C
The sheet tab is changed
D
The status bar does not display the cell address
Explanation: 

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: -It just lock your formula and you don’t even need to right again and again same formula in every row or column.

Detailed explanation-5: -Summary of absolute cell reference uses: $A1. Allows the row reference to change, but not the column reference. A$1. Allows the column reference to change, but not the row reference.

There is 1 question to complete.
Previous
Next