Data Analysis Tools in Excel (What-If Analysis, Goal Seek) MCQs

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