Match each of the following what-if analysis tools to its most likely use:I.Goal SeekII.SolverIII.Two-variable data tableIV.One-variable data tableV.Scenario ManagerA.You want to know what interest rate you need to find to make a loan payment exactly $500 per month.B.You want to compare the total interest paid on the lifetime of a loan with varying interest rates and terms.C.You want to know how many products your production line can make with the least waste.D.You want to compare best-case, worst case and most-likely case scenarios for a business decision.E.You want to compare different calculations like monthly payment and total interest paid on a loan with the different interest rates.

Fill in the blank(s) with the appropriate word(s).


A, C, B, E, D

Computer Science & Information Technology

You might also like to view...

When the left operand of a binary operation is a struct object:

A. the overloaded operator function for the binary operator must be written beneath the struct definition B. the overloaded operator function for the binary operator should be written inside the struct definition C. an overloaded operator function cannot be written for the binary operator D. a compiler error occurs

Computer Science & Information Technology

Smartphones include all of the following EXCEPT ________

A) a CPU B) a mouse C) storage capabilities D) ports

Computer Science & Information Technology

How can you fine-tune the composition of a photo for printing?

What will be an ideal response?

Computer Science & Information Technology

Columns in delimited text files are always vertically aligned as they would be in a spreadsheet.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology