2. Questions Bank
  3. 9th Class
  4. Computers Science
  5. Microsoft Excel

9th Class Computers Science Microsoft Excel Question Bank MS-Excel 2010

  • question_answer
    Rishab wants to add a condition to selected range of cells, such that when a user enters a value less than 0, it should display a message stating that only positive numbers can be entered. Which of the following can be used for this purpose?

    A) Consolidate    

    B)        Data Validation

    C) Data Restriction

    D)        What-lf Analysis

    Correct Answer: B

    Solution :

    To display a message when unwanted data is entered in a cell, select the range of cells, then go to Data Validation option, select Error Alert tab and type error message and click on OK button.


You need to login to perform this action.
You will be redirected in 3 sec spinner