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

  • question_answer
    Which of the following options will allow you to force the user to choose the value of a selected cell from the specified dropdown list in MS-Excel 2010?

    A) Data Validation 

    B) Consolidate

    C) What-lf Analysis

    D) Subtotal

    Correct Answer: A

    Solution :

    To display a drop-down list for a specific range of cells, select Data Validation option and select List in Allow field of Settings tab in Data Validation dialog box.


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