Question 1

What are the three types of charts available in Excel to illustrate model results?

Accepted Answer

The answer of What are the three types of charts...

Question 2

You can edit Excel formulas by either double-click the cell, or _________________

Accepted Answer

The answer of You can edit Excel formulas by either...

Question 3

Absolute references do _____________ change when you copy them.

Accepted Answer

The answer of Absolute references do _____________ change when you...

Question 4

A model is correct if it produces the _______________ correct _________ for the outputs for the current values of the inputs

Accepted Answer

The answer of A model is correct if it produces...

Question 5

__________ and ___________ cell referencing allows you to write one formula and then copy it.

Accepted Answer

The answer of __________ and ___________ cell referencing allows you...

Question 6

Data tables perform _____________ what-if ___________ quickly and easily.

Accepted Answer

The answer of Data tables perform _____________ what-if ___________ quickly...

Question 7

Describe the "IF" function in Excel.

Accepted Answer

The answer of Describe the "IF" function in Excel....

Question 8

The Excel function that returns the z-value of the standard normal distribution corresponding to a cumulative probability of p is _______

Accepted Answer

The answer of The Excel function that returns the z-value...

Question 9

Models transform inputs into ________________________

Accepted Answer

The answer of Models transform inputs into ________________________...

Question 10

Excel's COUNT function returns the ______ of cells containing numerical values.

Accepted Answer

The answer of Excel's COUNT function returns the ______ of...

Question 11

The sample standard deviation is found by using the Excel ___________ function.

Accepted Answer

The answer of The sample standard deviation is found by...

Question 12

The MATCH function returns the ________________ position in the array that matches the lookup value.

Accepted Answer

The answer of The MATCH function returns the ________________ position...

Question 13

Ideally, a spreadsheet model should be ________________________

Accepted Answer

The answer of Ideally, a spreadsheet model should be ________________________...

Question 14

__________ is the model that contains the "default" or "given" values for the inputs

Accepted Answer

The answer of __________ is the model that contains the...

Question 15

The Excel function that multiplies corresponding numbers in the two ranges and returns the sum of those products is the ________________ function.

Accepted Answer

The answer of The Excel function that multiplies corresponding numbers...

Question 16

Although there are a number of different model types, _________ exist among them.

Accepted Answer

The answer of Although there are a number of different...

Quiz 17: Spreadsheet Modeling: An Introduction

What are the three types of charts available in Excel to illustrate model results?