W4_Use Solver modeling_pop quiz_version1

The data is the first thing that should be entered in a spreadsheet model.

• True

• False

Data (for example, prices or costs) should be entered directly into every output cell as needed.

• True

• False

If you add rows or columns to a spreadsheet Excel will automatically adjust named ranges to compensate.

• True

• False

In the example shown below, cells B7 through B18 are inputs to cell B4.

• True

• False

The overall measure of performance in a spreadsheet model is represented by the changing cells in the model.

• True

• False

When testing a spreadsheet model by entering values in the changing cells, which of the following are appropriate values to enter?

• Zeroes

• Values for which you know what the values of the output cells should be

• Large numbers

• Zeros, large numbers, and inputs for which you know what the values of the output cells should be

• All of the answer choices are correct.

How many cells should be used to represent each constraint?

• 0

• 1

• 2

• 3

• 4

After pressing Ctrl+~ to toggle Excel to view formulas, an analyst reviews the spreadsheet shown below. Which of the following is TRUE?

• I only

• II only

• III only

• I and II

• I and III

A spreadsheet developer enters the formula "=$B$9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

• =$B$9*$B$10

• =C9*C10

• =C10*C11

• =$C$10*$C$11

• =$B$10*$B$11

Which of the following are valid range names in Excel?

1. Unit_Cost

2. UnitCost

3. Unit Cost

• I only

• III only

• II only

• I and II only

• I and III only