Please ans the following MCQ-

17. Macro is - Select the correct answer

Select one:

a. Is a single button to do routine tasks each time

b. Is very difficult to write

c. Requires technical knowledge to write it

d. Is a program which though written in Excel can be used outside of Excel too

18. Which statement best describes the What-if Analysis Scenario Manager?

Select one:

a. Allows to define input variables in various situations. The output result for each situation is show in a summary table.

b. Allows to define output results and then shows what input values are needed to generate that result.

c. Allows to see results of multiple inputs in the same formula and to get respective outputs.

19. The Sales manager presented sales analysis of the current and previous quarter to his senior management. This is

Select one:

a. Prescriptive Analysis

b. Predictive Analysis

c. Descriptive Analysis

d. None of these options

20. The primary source of Big Data is

Select one:

a. Smart Devices

b. Internet of Things (IoT)

c. All of these options

d. Social Media

Please give only right option no explanation required.