Scenarios in Spreadsheet - Class X

Which of the following is not a 'What-if Analysis' tool?

• Scenario

• Track Change

• Solver

• Goal Seek

'What-if Analysis' Goal Seeking'- Allows you to define output results and then shows what input values are needed to generate that result.

• True

• False

'What-if Analysis' Goal Seeking'- Allows you to investigate how changes to one or two input variables in a formula changes out results.

• True

• False

'What-if Analysis' Goal Seeking'- Allows you to define input variables in various situations. The output result for each situation is shown in a summary table.

• True

• False

'What-if Analysis' Solver'- Allows you to define input variables in various situations. The output result for each situation is shown in a summary table.

• True

• False

Which of the following is NOT an example of a 'What-if analysis'?

• Find how raises will affect employee salaries

• Find the five top sales people in a company

• Find the business profits for different levels of sales

• Find the loan payments based for different interest rates

Which 'What-if analysis' tool will help you solve the following problem? You want to figure out how to keep a car loan under Rs. 12000 a month.

• Goal Seeking

• Scenario

• Solver

• This cannot be solved.

You are a Production Manager. Considering you have limited resource material and budget to go for next production cycle. Which of the tool would help you analyse how much quantity should be produced to meet all the requirements?

• Goal Seeking

• Scenario

• Solver

• None of the above

__________ is when you change one or more values in a spreadsheet and then assess how those changes affect the calculated values.

• What-if Analysis

• Track Changes

• Save Changes

• All of these

___________ is a what-if analysis tool that calculates backward to obtain an input that would yield a given output.

• Solver

• Goal seek

• Scenario

• Consolidation