Question 1

When you create a scenario summary report, Excel generates it as a ____ in the workbook.
A) new worksheet
B) new table
C) new file
D) new chart

Accepted Answer

Excel generates the scenario summary report as a new worksheet in the workbook.

Question 2

Defined names can be deleted or edited in the ____ dialog box.
A) Name Manager
B) Name
C) Manager
D) Defined Names

Accepted Answer

The Name Manager dialog box allows users to manage defined names in a workbook, including deleting and editing them.

Question 3

You can use the Scenario Manager dialog box to change a scenario's ____.
A) values
B) defined names for cells
C) defined names for ranges
D) all of the above

Accepted Answer

The Scenario Manager dialog box allows you to change the values of the variables in the scenario. It does not allow you to change the defined names for individual cells or ranges.

Question 4

To view a scenario in the worksheet, click the scenario name in the Scenario Manager dialog box, and then click the ____ button.
A) Open
B) Show
C) Display
D) View

Accepted Answer

Clicking the "Show" button will display the selected scenario in the worksheet, allowing you to view and compare the changes made in each scenario. The other options (Open, Display, View) are not applicable in the context of the Scenario Manager.

Question 5

Scenario summary reports are created with ____ as the worksheet title.
A) Scenario Summary
B) Scenario
C) Summary
D) Scenario Summary Report

Accepted Answer

The most appropriate worksheet title for a scenario summary report is "Scenario Summary" since it clearly indicates the type of report being presented. This title is also consistent with standard naming conventions for reports.

Question 6

After you create a PivotTable report, you can analyze the information in a different form by generating an associated ____, which contains the same elements as a regular Excel chart.
A) ScenarioChart
B) PivotChart
C) Data Chart
D) Data File

Accepted Answer

A PivotChart is specifically designed to work with PivotTable reports and contains the same elements as a regular Excel chart. A ScenarioChart is a type of chart used to compare multiple scenarios or options, but it is not directly related to PivotTables. A Data Chart is a general term that could refer to any chart created using data in Excel, but again it is not specific to PivotTables. A Data File refers to a file containing data, but it is not a type of chart or report.

Question 7

Instead of listing all the cells, a scenario summary report shows the values for all ____ cells and for all indicated result cells for all scenarios.
A) changing
B) moving
C) formula
D) relative

Accepted Answer

A scenario summary report only shows the values for changing cells (cells that are varied between different scenarios) and indicated result cells (cells whose values are affected by the changing cells).

Question 8

Scenario names can contain up to 255 characters, including spaces. However, only the first ____ characters of the scenario name appear in the Scenario Manager list.
A) 15
B) 25
C) 35
D) 45

Accepted Answer

The first 32 characters of the scenario name appear in the Scenario Manager list.

Question 9

Although you can use generic names for your scenarios, you should use more descriptive names because they appear on any scenario summary reports you ____.
A) create
B) print
C) both a and b
D) neither a nor b

Accepted Answer

Scenario summary reports can be both created and printed, so using descriptive names for scenarios helps in identifying them easily in any reports you generate, whether they are viewed digitally or in printed form.

Question 10

Open the Scenario Manager by clicking the DATA tab on the ribbon, clicking the ____ analysis button in the Data Tools group, and then clicking Scenario Manager.
A) What-If
B) Sensitivity
C) Break-Even
D) Contribution

Accepted Answer

The Scenario Manager function is used to perform What-If analysis on a spreadsheet. Therefore, the correct choice is A) What-If. B) Sensitivity analysis is used for determining the effect of changing one variable on another. C) Break-Even analysis is used to determine the point at which revenue equals expenses. D) Contribution analysis is used to determine the contribution margin of each product or service.

Question 11

You set up and print both types of scenario reports from the Scenario Manager dialog box by clicking the ____ button to open the Scenario Summary dialog box.
A) Summary
B) Scenario
C) Print
D) Scenario Summary

Accepted Answer

The correct choice is "Summary" because in the Scenario Manager dialog box in Excel, you click the "Summary" button to open the Scenario Summary dialog box, where you can set up and print both types of scenario reports.

Question 12

Changing cells and result cells are listed by the names you gave them when you ____.
A) created the scenarios
B) ran a report
C) saved the file
D) none of the above

Accepted Answer

Changing cells and result cells are listed by the names you gave them when you created the scenarios, which allows you to easily reference and manipulate them as needed for scenario analysis. Running a report or saving the file does not affect how the cells are named or referenced.

Question 13

A ____ extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.
A) PivotTable
B) PivotData
C) PivotSummary
D) PivotFile

Accepted Answer

A PivotTable extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.

Question 14

After you create a scenario, you can use the Scenario Manager ____ to change its values to extend your what-if analysis.
A) dialog box
B) toolbar
C) status bar
D) Wizard

Accepted Answer

The Scenario Manager dialog box allows you to view, edit, and create scenarios in Excel. Within this dialog box, you can change the values of your scenarios and analyze the impact of these changes on your data using Excel's what-if analysis tools. The toolbar and status bar are interface elements that do not allow you to edit the values of your scenarios, and the Wizard is a tool for creating new scenarios rather than editing existing ones.

Question 15

____ results are those that are based on realistic but not actual data.
A) Simulated
B) Fictional
C) Approximated
D) Produced

Accepted Answer

Simulated results are based on simulations that use models to generate data that approximates real-world scenarios, but may not be based on actual data. Fictional results are entirely imaginary, while approximated and produced results may be based on actual data but are not necessarily generated through simulation.

Question 16

Although a PivotTable usually summarizes information into different categories using functions such as ____, a scenario PivotTable lets you summarize the result cells from a scenario.
A) COUNT
B) AVERAGE
C) MAX
D) all of the above

Accepted Answer

All three functions (COUNT, AVERAGE, MAX) are commonly used in PivotTables to summarize data, and a scenario PivotTable allows you to summarize the result cells from a scenario by applying these functions to the scenario values.

Question 17

You can use the Scenario Manager to create two types of scenario reports: a scenario summary and a scenario ____.
A) Flow Chart
B) PivotTable
C) Workbook
D) Data Chart

Accepted Answer

The only option mentioned that would make sense as a type of report generated by a scenario is a PivotTable. A PivotTable can summarize and analyze different scenarios created in the Scenario Manager, making it the most logical choice for a scenario report.

Question 18

You use the ____ to add a scenario.
A) Scenario Wizard
B) Scenario Manager
C) Case Manager
D) Data Table Manager

Accepted Answer

The Scenario Manager is used to add, edit, and manage scenarios in Microsoft Excel. The Scenario Wizard is used to help create scenarios, but it is not the tool used to actually add them. The Case Manager and Data Table Manager are not tools used for scenarios in Excel.

Question 19

To make the scenario summary easy to interpret and distribute, Excel ____.
A) shades the changing cell values
B) shades the cell names
C) puts the report into a tabular format
D) all of the above

Accepted Answer

Excel makes scenario summaries easy to interpret and distribute by shading the changing cell values, shading the cell names, and putting the report into a tabular format.

Question 20

Before printing a scenario report, you indicate which ____ cells are of interest to you.
A) result
B) formula
C) error
D) defined

Accepted Answer

Scenario reports are used to analyze how changes in certain input cells can affect results. Therefore, the cells of interest in scenario reports are usually the result cells.

Quiz 8: Using Data Tables and Excel Scenarios for What If Analysis

When you create a scenario summary report, Excel generates it as a ____ in the workbook.

Defined names can be deleted or edited in the ____ dialog box.

You can use the Scenario Manager dialog box to change a scenario's ____.

To view a scenario in the worksheet, click the scenario name in the Scenario Manager dialog box, and then click the ____ button.

Scenario summary reports are created with ____ as the worksheet title.

After you create a PivotTable report, you can analyze the information in a different form by generating an associated ____, which contains the same elements as a regular Excel chart.

Instead of listing all the cells, a scenario summary report shows the values for all ____ cells and for all indicated result cells for all scenarios.

Scenario names can contain up to 255 characters, including spaces. However, only the first ____ characters of the scenario name appear in the Scenario Manager list.

Although you can use generic names for your scenarios, you should use more descriptive names because they appear on any scenario summary reports you ____.

Open the Scenario Manager by clicking the DATA tab on the ribbon, clicking the ____ analysis button in the Data Tools group, and then clicking Scenario Manager.

You set up and print both types of scenario reports from the Scenario Manager dialog box by clicking the ____ button to open the Scenario Summary dialog box.

Changing cells and result cells are listed by the names you gave them when you ____.

A ____ extracts, organizes, and summarizes data so you can analyze it by making comparisons, detecting patterns and relationships, and recognizing trends.

After you create a scenario, you can use the Scenario Manager ____ to change its values to extend your what-if analysis.

____ results are those that are based on realistic but not actual data.

Although a PivotTable usually summarizes information into different categories using functions such as ____, a scenario PivotTable lets you summarize the result cells from a scenario.

You can use the Scenario Manager to create two types of scenario reports: a scenario summary and a scenario ____.

You use the ____ to add a scenario.

To make the scenario summary easy to interpret and distribute, Excel ____.

Before printing a scenario report, you indicate which ____ cells are of interest to you.