Question 1

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 2

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 3

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 4

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 5

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 shows the values for all changing cells and for all indicated result cells for all scenarios. It does not list all the cells, but only those that are relevant to the scenarios being analyzed.

Question 6

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

The correct choice is "Show" as it is the button that is used to display/view the selected scenario in the worksheet.

Question 7

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 What-If analysis button in the Data Tools group is the one that opens the Scenario Manager, which allows you to create and compare different scenarios based on changing input values. Sensitivity analysis, Break-Even analysis, and Contribution analysis are other tools that can be used in Excel, but they are not directly related to the Scenario Manager.

Question 8

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

Accepted Answer

The scenario report shows the results of different scenarios for specific cells. Therefore, it is important to indicate which result cells are of interest to you before printing the report.

Question 9

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

After creating a PivotTable report, you can create an associated PivotChart, which displays the PivotTable data in a graphical format. It contains the same elements as a regular Excel chart but is linked to the underlying PivotTable, allowing you to explore the data in a more visual manner.

Question 10

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 change the values of the scenario and perform what-if analysis by creating different scenarios based on the data. The toolbar and status bar do not provide options to change scenario values, and the Wizard is used to create new scenarios.

Question 11

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 Scenario Manager can be used to create a scenario summary report or a scenario PivotTable report. Therefore, the best choice would be B, PivotTable.

Question 12

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 is used to change the values of a scenario. It does not have the capability to change defined names for cells or ranges.

Question 13

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 of the above functions (COUNT, AVERAGE, MAX) can be used in a PivotTable to summarize information into different categories. However, a scenario PivotTable specifically allows you to summarize the results of scenarios, rather than just raw data.

Question 14

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 part of scenario manager and are created when scenarios are created. Therefore, the names are given at the time of scenario creation which corresponds to choice A. Saving the file or running a report does not change the names given to the cells.

Question 15

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 16

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 is a tool used in Microsoft Excel to extract and summarize data. It allows for easy analysis by making comparisons, detecting patterns and relationships, and recognizing trends. PivotTables are commonly used in data analysis to quickly and efficiently extract insights from large sets of data.

Question 17

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

Accepted Answer

Simulated results refer to outcomes that are generated by a computer program or model using hypothetical scenarios or assumptions based on real-world data. These results are not actual, but they are intended to provide insights into how a particular system or process may perform under certain conditions. Option B) Fictional refers to imaginary or invented results that are not based on any real-world data, and option C) Approximated refers to results that are based on an estimation or approximation of actual data. Option D) Produced is too general and does not accurately describe the type of results being referred to in the question.

Question 18

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

Accepted Answer

Using "Scenario Summary" as the worksheet title accurately and clearly communicates the purpose of the report.

Question 19

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 is specifically designed to manage and manipulate defined names in a worksheet. It allows users to edit, delete or modify names in a convenient and user-friendly manner.

Question 20

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, delete, and manage scenarios in Excel. The Scenario Wizard is a tool within the Scenario Manager that helps to guide you through the process of creating a scenario. The Case Manager and Data Table Manager are not relevant to adding scenarios.

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

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

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

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.

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.

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.

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

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.

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

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.

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

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

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

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.

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

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

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

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

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

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

You use the ____ to add a scenario.