Question 1

-The item marked 4 in the accompanying figure indicates the _______ expenses.

Accepted Answer

A) fixed 
B) mixed 
C) variable 
D) absolute 
A) fixed 
B) mixed 
C) variable 
D) absolute A

Question 2

A(n)$\underline {  \text { mixed }  }$ expense is an expense that is part variable and part fixed._________________________

Accepted Answer

A) True 
 B)False  True

Question 3

-The item marked 3 in the accompanying figure indicates the _______ expenses.

Accepted Answer

A) fixed 
B) mixed 
C) variable 
D) absolute 
A) fixed 
B) mixed 
C) variable 
D) absolute C

Question 4

When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.

Accepted Answer

The answer of When creating a(n)____________________ data table,you must identify...

Question 5

An array $\underline {\text { argument } }$ performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

Accepted Answer

A) True 
 B)False

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Adds commands and features to Excel

Accepted Answer

A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result 
A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result

Question 7

-The item marked 2 in the accompanying figure is the _______ point.

Accepted Answer

A) variable 
B) fixed 
C) break-even 
D) absolute 
A) variable 
B) fixed 
C) break-even 
D) absolute

Question 8

The three items that you must specify when using Solver are _______.

Accepted Answer

A) target cell, input value, and results 
B) target cell, variable cell, and parameters 
C) variable cell, parameters, and constraints 
D) variable cell, objective cell, and constraints 
A) target cell, input value, and results 
B) target cell, variable cell, and parameters 
C) variable cell, parameters, and constraints 
D) variable cell, objective cell, and constraints

Question 9

____________________ constraints always show a slack of 0.

Accepted Answer

The answer of ____________________ constraints always show a slack of...

Question 10

To calculate multiple cell values,select the range and type the array formula,then press the _______ keys to enter the formula.

Accepted Answer

A) Alt+Enter 
B) Ctrl+Shift+Enter 
C) Alt+Shift+Enter 
D) Ctrl+Enter 
A) Alt+Enter 
B) Ctrl+Shift+Enter 
C) Alt+Shift+Enter 
D) Ctrl+Enter

Question 11

Aria explains that there are six possible constraints supported by Solver.Which of the following is one of those constraints?

Accepted Answer

A) != 
B) >= 
C)    
D) # 
A) != 
B) >= 
C)    
D) #

Question 12

$\underline { \text { Goal Seek }   }$ is a program that searches for the optimal solution of a problem involving several variables._________________________

Accepted Answer

A) True 
 B)False

Question 13

The default length of time that Solver will spend on the iterative process is _______ seconds.

Accepted Answer

A) 50 
B) 100 
C) 500 
D) 1000 
A) 50 
B) 100 
C) 500 
D) 1000

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Cells whose values you will change within each scenario

Accepted Answer

A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result 
A) Solver 
B) changing 
C) constraint 
D) add-in 
E) answer report
F)nonbinding
G)Goal Seek
H)slack
I)limits report
J)result

Question 15

You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis.
-First you must understand break-even analysis.The definition of break-even point is where the total revenue _______ total expenses.

Accepted Answer

A) is less than 
B) is greater than 
C) equals 
D) exceeds 
A) is less than 
B) is greater than 
C) equals 
D) exceeds

Question 16

With Goal Seek,you specify the _______ values you want.

Accepted Answer

A) result 
B) constraint 
C) exchange 
D) index 
A) result 
B) constraint 
C) exchange 
D) index

Question 17

In a data table,____________________ cells are cells whose values are impacted by the changing input cells.

Accepted Answer

The answer of In a data table,____________________ cells are cells...

Question 18

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.

Accepted Answer

A) FALSE 
B) NO 
C) 1 
D) 0 
A) FALSE 
B) NO 
C) 1 
D) 0

Question 19

Goal Seek uses a different approach from traditional _______ analysis.

Accepted Answer

A) trial-and-error 
B) what-if 
C) worksheet 
D) hypothetical 
A) trial-and-error 
B) what-if 
C) worksheet 
D) hypothetical

Question 20

A(n)_______ is a limit that is placed on a Solver problem's solution.

Accepted Answer

A) max 
B) target 
C) constraint 
D) adjustment 
A) max 
B) target 
C) constraint 
D) adjustment

-The item marked 4 in the accompanying figure indicates the _______ expenses.

A(n) $\underline { \text { mixed } }$ expense is an expense that is part variable and part fixed._________________________

-The item marked 3 in the accompanying figure indicates the _______ expenses.

When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.

An array $\underline {\text { argument } }$ performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds commands and features to Excel

-The item marked 2 in the accompanying figure is the _______ point.

The three items that you must specify when using Solver are _______.

____________________ constraints always show a slack of 0.

To calculate multiple cell values,select the range and type the array formula,then press the _______ keys to enter the formula.

Aria explains that there are six possible constraints supported by Solver.Which of the following is one of those constraints?

$\underline { \text { Goal Seek } }$ is a program that searches for the optimal solution of a problem involving several variables._________________________

The default length of time that Solver will spend on the iterative process is _______ seconds.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells whose values you will change within each scenario

With Goal Seek,you specify the _______ values you want.

In a data table,____________________ cells are cells whose values are impacted by the changing input cells.

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.

Goal Seek uses a different approach from traditional _______ analysis.

A(n)_______ is a limit that is placed on a Solver problem's solution.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 10: Performing What If Analyses

-The item marked 4 in the accompanying figure indicates the _______ expenses.

A(n) mixed ‾\underline { \text { mixed } } mixed ​ expense is an expense that is part variable and part fixed._________________________

-The item marked 3 in the accompanying figure indicates the _______ expenses.

When creating a(n)____________________ data table,you must identify the row input cell and the column input cell.

An array argument ‾\underline {\text { argument } } argument ​ performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds commands and features to Excel

-The item marked 2 in the accompanying figure is the _______ point.

The three items that you must specify when using Solver are _______.

____________________ constraints always show a slack of 0.

To calculate multiple cell values,select the range and type the array formula,then press the _______ keys to enter the formula.

Aria explains that there are six possible constraints supported by Solver.Which of the following is one of those constraints?

Goal Seek ‾\underline { \text { Goal Seek } } Goal Seek ​ is a program that searches for the optimal solution of a problem involving several variables._________________________

The default length of time that Solver will spend on the iterative process is _______ seconds.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cells whose values you will change within each scenario

With Goal Seek,you specify the _______ values you want.

In a data table,____________________ cells are cells whose values are impacted by the changing input cells.

If a value in the worksheet violates one of the constraints,the Solver parameter cells will display the value _______.

Goal Seek uses a different approach from traditional _______ analysis.

A(n)_______ is a limit that is placed on a Solver problem's solution.

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

A(n) $\underline { \text { mixed } }$ expense is an expense that is part variable and part fixed._________________________

An array $\underline {\text { argument } }$ performs multiple calculations on one or more sets of values and then returns either a single value or multiple values._________________________

$\underline { \text { Goal Seek } }$ is a program that searches for the optimal solution of a problem involving several variables._________________________