What happens when dollar signs ($) are entered in a cell ...
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
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
Correct answer is A
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
Changing the appearance of a Microsoft Word document is called ...
What is the keyboard shortcut to insert a SUM formula in MS Excel? ...
You can check the conditions against _________ when applying conditional formatting in Excel. ...
In Excel, comments put in cells are called ...
Under which menu can we insert Header and Footer in an Excel sheet? ...
In MS Access Datasheet View, what appears at the top of each column? ...
Which function is used to find the sum of complex numbers in MS Excel? ...
Which of the following formulas is not entered correctly? ...