answer the following MCQs without explanation-

a) Scenario manager - select the incorrect answer

Select one:

O a. Can create a Scenario summary

O b. Can create a scenario pivot table report

O c. Can create an Answer report

d. Can give a final result after impact of changes in many variables

b)Which of the following function will generate 7 as output?

Select one:

O a. =SEARCH(e, welcome",

O b. =SEARCH('e","welcome",3)

O c. =SEARCH('e","welcome",2)

O d. =SEARCH('e","welcome")

c) In Goal Seek - select the incorrect answer

Select one:

O a. The function essentially uses trial and error approach, until it gets an answer

O b. For Revenue=Number of units sold*Selling price. Goal seek can find out what should be the selling price to achieve a revenue of Rs 100000, if quantity sold is known

O c. Goal seek is not there on the worksheet, it needs to be added in by using the "Options" tab

O d. For Revenue=Number of units sold*Selling price. Goalseek can find out. how many units are to be sold to achieve a revenue of Rs 100000, if the selling price is known

d) The sales manager uses Solver to decide the product prices to optimize the profit. This is

Select one:

O a. None of these options

O b. Prescriptive Analysis

O c. Descriptive Analysis

O d. Predictive Analysis