1. Which Excel function can be used to perform a sensitivity analysis?

A) Goal Seek
B) Data Tables
C) Scenario Manager
D) Forecasting



2. Which of the following Excel features is used to determine the optimal value of a cell based on a specific goal?

A) What-If Analysis
B) Scenario Manager
C) Goal Seek
D) Solver



3. Which of the following is an example of a data visualization tool in Excel?

A) VLOOKUP function
B) Scenario Manager
C) Trend Analysis
D) Pie chart



4. Which of the following statements about the Scenario Manager in Excel is true?

A) It is used to create and compare multiple scenarios based on different inputs.
B) It is used to create custom charts and graphs.
C) It is used to analyze large data sets using statistical functions.
D) It is used to validate and check the accuracy of data entered into a worksheet.



5. Which Excel tool can be used to perform optimization and find the best solution to a problem?

A) Solver
B) Goal Seek
C) Scenario Manager
D) Trend Analysis