What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

Related MCQs

• How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
• In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
• In Excel when you are typing an equation into a cell the first thing that must be entered is
• What value will display if the formula = “$55.00″+5 is entered into a cell?
• If 4/6 entered in a cell without applying any formats, Excel will treat this as
• Excel displays the current cell address in the ……….
• Give me an example of a cell address.
• In Excel you can copy cell formats from one cell to another by using the
• In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
• In Excel if you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you