70.2K

Verified Solution

Link Copied!

Choose the correct answer without explanation

Question 11 Not yet answered Marked out of 2.00 Flag question You can Open the Scenario Manager Dialog Box by Choosing Scenarios from the Tab of Ribbon. a. Insert b. View C. Data d. Formulas Question 12 Not yet answered Marked out of 2.00 Flag question Which option of Data Tool Group Will Give the option of Scenario Manager? a. Data Validation b. Consolidate c. What-if Analysi- Question 13 Not yet answered Marked out of 2.00 P Flag question Which of the following statements about scenarios in an Excel workbook is not true? a. Scenarios help you in what-if analysis. b. scenario is a set of values saved with the workbook. A workbook can have one scenario per sheet. d. Scenarios provide a way to see different solutions for worksheet formulas. Question 14 Not yet answered Marked out of 2.00 Flag question You can Open the PMT Dialog Box by choosing PMT option from the Tab of Ribbon? a. View b. Formulas C. Insert d. Data Question 15 Not yet answered Marked out of 2.00 P Flag question Excel Goal Seek Formulas consist of: a. By changing cell: The cell you would like to change to reach your goal value. b. To value: The value you want as your goal. C. all of the above d. Set cell: The cell you want to use as your goal

Answer & Explanation Solved by verified expert

See Answer