1. Which of the following is NOT a What-If Analysis tool in Excel?
(A) Scenario Manager
(B) Goal Seek
(C) Data Table
(D) VLOOKUP
2. The Goal Seek tool in Excel is used to:
(A) Find multiple solutions at once
(B) Calculate averages of data
(C) Adjust input values to achieve a desired result
(D) Create pivot tables
3. In Goal Seek, you must specify all of the following EXCEPT:
(A) Set Cell
(B) Range of Cells
(C) By Changing Cell
(D) To Value
4. What-If Analysis in Excel is mainly used for:
(A) Formatting cells
(B) Forecasting and decision making
(C) Sorting and filtering data
(D) Inserting charts
5. A Data Table in What-If Analysis is primarily used for:
(A) Testing formulas with different input values
(B) Formatting data into tabular form
(C) Sorting large datasets
(D) Protecting worksheets