Student Resources: Lesson Quizzes

Lesson 15: Using What-If Analysis

	1.	What term refers to a specific set of values saved with the workbook?

		a.	Range
		b.	Scenario
		c.	Trendline
		d.	What-if analysis

	2.	You can open the Scenario Manager dialog box by choosing Scenarios from the __________ menu.

		a.	View
		b.	Insert
		c.	Format
		d.	Tools

	3.	A trendline is a line in a chart that points out and predicts general tendencies or directions in the values.

		a.	TRUE
		b.	FALSE

	4.	What feature enables you to adjust or “backsolve” the value in a cell to reach a desired outcome in a formula?

		a.	Goal Seek
		b.	Scenario summary report
		c.	Forecasting
		d.	Trendline

	5.	Solver is useful for more complex backsolving problems.

		a.	TRUE
		b.	FALSE