How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

Related MCQs

• How to restrict to run a macro automatically when starting Microsoft Excel?
• 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 happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
• 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
• In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
• In Excel a fast way to add up this column of number is to click in the cell below the numbers and then
• Which of the following options is appropriate to show the numbers 9779851089510 in a cell?
• If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must