QUESTION 8 A one-way data table summarizes a single input’s impact on the output

Question

QUESTION 8

A one-way data table summarizes

a single input’s impact on the output of interest

values of the input cells that will cause the single output value to equal zero

multiple input’s impact on a single output of interest

values of cells when not all of the model is observable on the screen

1 points   

QUESTION 9

The impact of two inputs on the output of interest is given by a _____

Goal Seek

Watch Window

one-way data table

two-way data table

1 points   

QUESTION 10

The _____ function pairs each element of the first array with its counterpart in the second array, multiplies the elements of the pairs together, and adds the results

SUM

COUNTIF

IF

SUMPRODUCT

1 points   

QUESTION 11

Within a given range of cells, the number of times a particular condition is satisfied is computed by using the _____ function

IF

SUMIF

COUNTIF

VLOOKUP

a single input’s impact on the output of interest

values of the input cells that will cause the single output value to equal zero

multiple input’s impact on a single output of interest

values of cells when not all of the model is observable on the screen

Explanation / Answer

Question 8) A. A single inputs impact on the output of interest

Question 9) D.Two way data table

Question 10) D. Sum SUMPRODUCT

Question 11)D. VLOOKUP

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.