Filters
Question type
Study Flashcards

Goal Seek can be set to minimize the objective cell.

Correct Answer

verifed

verified

All what-if analysis tools are located in the ________ tab.

Correct Answer

verifed

verified

Scenario Manager can be set to maximize the objective cell.

Correct Answer

verifed

verified

Match the following terms with the corresponding description.

Premises
Solver
Variable
Objective cell
Goal Seek
Scenario Manager
Responses
An add-in application that manipulates variables based on constraints to find the optimal solution to a problem
An input value that can change to other values to affect the results of a situation
Specifies the cell that contains a formula that produces a value that you want to optimize
A tool that identifies the necessary input value to obtain a desired goal
Enables you to define and manage scenarios to compare how they affect results

Correct Answer

Solver
Variable
Objective cell
Goal Seek
Scenario Manager

What is the best tool to determine the required downpayment to reach a $700 car payment?


A) Solver
B) Goal Seek
C) Scenario Manager
D) One-variable data table

Correct Answer

verifed

verified

Match the following terms with the corresponding description.

Premises
Scenario Summary Report
Comments
Scenario Manager
Scenario
Changing cells
Responses
Cells containing scenario variables
Notes regarding the creation date of a scenario
An organized structured table of the scenarios,their input values,and their respective results
Enables you to define and manage scenarios to compare how they affect results
Detailed sets of values that represent different possible situations

Correct Answer

Scenario Summary Report
Comments
Scenario Manager
Scenario
Changing cells

Which of the following tools can manipulate changing variable cells?


A) Goal Seek
B) One-variable data table
C) Two-variable data table
D) Solver

Correct Answer

verifed

verified

Goal Seek is an Excel add-in.

Correct Answer

verifed

verified

What is the maximum number of scenarios supported by Scenario Manager?


A) 23
B) 45
C) 32
D) 50

Correct Answer

verifed

verified

Which of the following tools is best suited for comparing the effects of two variables on a formula?


A) Solver
B) Goal Seek
C) Two-variable data table
D) One-variable data table

Correct Answer

verifed

verified

Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?


A) Goal Seek
B) Solver
C) Scenario Manager
D) Two-variable Data Table

Correct Answer

verifed

verified

A two-variable data table allows two variables but only one result.

Correct Answer

verifed

verified

Where do scenario summary reports appear?


A) A new worksheet
B) A new workbook
C) The current worksheet
D) A pop up box

Correct Answer

verifed

verified

________ scenarios can be created within Scenario Manager.

Correct Answer

verifed

verified

Which dialog box enables you to specify the result cells for a scenario summary report?


A) Scenario Summary
B) Scenario Values
C) Add Scenario
D) Solver Options

Correct Answer

verifed

verified

________ is the best what-if analysis tool to solve complex linear and nonlinear problems.


A) Goal Seek
B) Solver
C) One-variable data table
D) Scenario Manager

Correct Answer

verifed

verified

Scenario Manager can create PivotTable reports.

Correct Answer

verifed

verified

A(n)________ specifies the cell that contains a formula that produces a value that you want to optimize with Solver.

Correct Answer

verifed

verified

If Doug would like to determine how many hot dogs to sell at a profit margin of $10.00 to raise $250.00 without constraints,which what-if analysis tool should he use?


A) Scenario Manager
B) Goal Seek
C) Solver
D) Two-variable data table

Correct Answer

verifed

verified

Scenario Manager is an Excel add-in.

Correct Answer

verifed

verified

Showing 81 - 100 of 103

Related Exams

Exam 1

Office Fundamentals and File Management

100 Questions

Exam 3

Word: Document Presentation: Editing and Formatting

100 Questions

Exam 4

Word: Document Productivity: Working With Tables and Mail Merge

100 Questions

Exam 5

Word: Collaboration and Research: Communicating and Producing Professional Papers

100 Questions

Exam 6

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

100 Questions

Exam 7

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

100 Questions

Exam 8

Word: Document Automation: Forms,macros,and Security

100 Questions

Exam 9

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

104 Questions

Exam 10

Power: Introduction to Powerpoint: Creating a Basic Presentation

108 Questions

Exam 11

Power: Presentation Development: Planning and Preparing a Presentation

111 Questions

Exam 12

Power: Presentation Design: Illustrations and Infographics

102 Questions

Exam 13

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

100 Questions

Exam 14

Power: Infographics: Creating Text Charts, tables, and Graphs

100 Questions

Exam 15

Power: Interactivity and Advanced Animation: Engaging the Audience

100 Questions

Exam 16

Power: Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 17

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

100 Questions

Exam 18

Excel: Introduction to Excel: What Is a Spreadsheet

100 Questions

Exam 19

Excel: Formulas and Functions: Performing Quantitative Analysis

100 Questions

Exam 20

Excel : Charts: Depicting Data Visually

100 Questions

Exam 21

Excel: Datasets and Tables: Managing Large Volumes of Data

100 Questions

Exam 22

Excel: Subtotals, Pivot-tables, and Pivot-charts

103 Questions

Exam 24

Excel: Specialized Functions

103 Questions

Exam 25

Excel: Statistical Functions

103 Questions

Exam 26

Excel : Multiple-Sheet Workbook Management

103 Questions

Exam 27

Excel: Imports, web Queries, and Xml

103 Questions

Exam 28

Excel : Collaboration and Workbook Distribution

108 Questions

Exam 29

Excel: Templates, styles, and Macros

103 Questions

Exam 30

Access : Introduction to Access: Finding Your Way Through an Access Database

100 Questions

Exam 31

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

100 Questions

Exam 32

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

100 Questions

Exam 33

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

100 Questions

Exam 34

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

100 Questions

Exam 35

Access : Action and Specialized Queries: Moving Beyond the Select Query

100 Questions

Exam 36

Access: Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 37

Access: Get Connected: Exchanging Data Between Access and Other Applications

100 Questions

Exam 38

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

100 Questions

Show Answer