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

  • question_answer
    Which of the following statements hold(s) true about the given dialog box? 
     
    Statement 1: The "Set cell" must contain the formula. 
    Statement 2: Only one cell value can be supplied in "By changing cell" field.
     

    A) Only Statement 1

    B) Only Statement 2

    C) Both Statement 1 and Statement 2

    D) Neither Statement 1 nor Statement 2

    Correct Answer: C

    Solution :

    The Goal Seek function, allows the user to use the desired result of a formula to find the possible input value necessary to achieve that result.


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