BIS 155 Week 6 Quiz

Question 1

(TCO 6) What What-If Analysis tool would you use to compare the impact of different interest rates on a car payment?

  One-variable data table

  Solver

  Goal Seek

  Two-variable data table

Question 2

(TCO 6) What is the maximum number of scenarios supported by Scenario Manager?

  23

  45

  32

  50

Question 3

(TCO 6) When creating a one-variable data table that depicts the effect of different interest rates on a car payment, the interest rate is an example of which of the following?

  Variable

  Constraint

  Objective cell

  Set cell

Question 4

(TCO 6) The _____ value replaces the original input value of the variable in a data table

  replacement

  substitution

  trial

  sample

 

Question 5

(TCO 6) In order to complete a two-variable data table, which of the following must be included in the table?

  Formula

  Constraint

  Absolute reference

  Integer

Question 6

(TCO 6) ) In the Goal Seek dialog box, the cell reference of the desired value is entered in the _____ box

  to value

  by changing cell

  set cell

  column input cell

Question 7

(TCO 6) Which What-If Analysis tool is best used for creating optimization models?

  One-variable data table

  Two-variable data table

  Solver

  Goal Seek

Question 8

(TCO 6) When using Solver, the _____ cell contains the formula used to optimize the results

  objective

  pivotal

  changing

  optimizing

Question 9

 

(TCO 6) When saving a Solver model, which of the following is not saved?

  Objective value

  Changing variable cells

  Consgtraints

  Set cell

Question 10

(TCO 6) To compare monthly mortgage payments based on varying the interest rate and the cost of the house, you would use _____

  Scenario Manager

You Answered

  a two-variable data table

  a multi-variable data table

  Goal Seek

Question 11

(TCO 6) This analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals

  Goal Seek

  Scenario Manager

  Solver

  Two-variable data table

Question 12

(TCO 6) How can you determine if the Solver add-in is active?

  Solver is an option on the Home tab

  Solver appears on the Data tab

  Solver is available via right-click

  Solver appears in the Goal Seek dialog box

Question 13

 

(TCO 6) Which of the following What-If Analysis tools updates data in real time?

  Solver

  Goal Seek

  Scenario Manager

  One-variable data table

Question 14

(TCO 6) Where should the formula or formula reference be located in a two-variable date table?

  Lower right corner

  Upper right corner

  Top left corner

  Lower left corner

Question 15

(TCO 6) Where do scenario summary reports appear?

  A new worksheet

  A new workbook

  The current worksheet

 

  A pop-up box

SmartExpert

(118)

Status NEW Posted 03 Dec 2017 12:12 PM My Price 7.00

-----------

Attachments

file 1512308367-BIS 155 Week 6 Quiz.docx preview (520 words )

B-----------IS -----------155----------- We-----------ek -----------6 Q-----------uiz----------- Q-----------ues-----------tio-----------n 1----------- (-----------TCO----------- 6)----------- Wh-----------at -----------Wha-----------t-I-----------f A-----------nal-----------ysi-----------s t-----------ool----------- wo-----------uld----------- yo-----------u u-----------se -----------to -----------com-----------par-----------e t-----------he -----------imp-----------act----------- of----------- di-----------ffe-----------ren-----------t i-----------nte-----------res-----------t r-----------ate-----------s o-----------n a----------- ca-----------r p-----------aym-----------ent-----------? ----------- O-----------ne------------var-----------iab-----------le -----------dat-----------a t-----------abl-----------e ----------- -----------Sol-----------ver----------- ----------- G-----------oal----------- Se-----------ek ----------- ----------- Tw-----------o-v-----------ari-----------abl-----------e d-----------ata----------- ta-----------ble----------- -----------Que-----------sti-----------on -----------2 -----------(TC-----------O 6-----------) W-----------hat----------- is----------- th-----------e m-----------axi-----------mum----------- nu-----------mbe-----------r o-----------f s-----------cen-----------ari-----------os -----------sup-----------por-----------ted----------- by----------- Sc-----------ena-----------rio----------- Ma-----------nag-----------er?----------- ----------- 23----------- ----------- 4-----------5 ----------- -----------32 ----------- ----------- 50----------- -----------Que-----------sti-----------on -----------3 -----------(TC-----------O 6-----------) W-----------hen----------- cr-----------eat-----------ing----------- a -----------one------------va-----------ria-----------ble----------- da-----------ta -----------tab-----------le -----------tha-----------t d-----------epi-----------cts----------- th-----------e e-----------ffe-----------ct

Not Rated(0)

• Buy Answer