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.
Which of the following is a type of checkbox available in MS Word? ...
What is the correct way to refer to cell A10 on sheet3 from sheet1? ...
Under which tab can chart options be found in MS Excel? ...
The default and maximum size of text field in MS Access is ...
The shortcut key Ctrl + R is used in Excel to ...
With which view can you see how text and graphics will appear on the printed page? ...
In Excel, hyperlinks can be ...
When all the numbers between 0 and 100 in a range should be displayed in red color, apply ...
Which of the following options is not available in Excel Paste Special dialog box? ...
In Excel, which symbol is used to specify the fixed columns or rows in the formula? ...