Question 1

When an analyst enters data into a model to see if the results match expectations, which step of the modeling process is occurring?

Accepted Answer

A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct. 
A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct. C

Question 2

Colors and shading can be used to make a spreadsheet model much easier to read and interpret.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A)  Cell B2 is a data cell. 
B)  Cell B3 is a formula cell. 
C)  Cell B6 is a data cell. 
D)  Cell B6 is a formula cell. 
E)  Only A and D are true. 
A)  Cell B2 is a data cell. 
B)  Cell B3 is a formula cell. 
C)  Cell B6 is a data cell. 
D)  Cell B6 is a formula cell. 
E)  Only A and D are true. E

Question 4

In the spreadsheet shown below, which of the following is a data cell?

Accepted Answer

A)  Cell B1. 
B)  Cell B7. 
C)  Cell D7. 
D)  Cell D18. 
E)  All of the answer choices are data cells. 
A)  Cell B1. 
B)  Cell B7. 
C)  Cell D7. 
D)  Cell D18. 
E)  All of the answer choices are data cells.

Question 5

Before building a full-scale version of her spreadsheet model, Julie constructs a smaller version of the spreadsheet. Julie is performing which step of the modeling process?

Accepted Answer

A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct. 
A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct.

Question 6

Which of the following are ways to distinguish data cells, changing cells, output cells, and the objective cell on a spreadsheet?

Accepted Answer

A)  Borders. 
B)  Shading. 
C)  Color. 
D)  All of the answer choices are correct. 
E)  Borders and color only. 
A)  Borders. 
B)  Shading. 
C)  Color. 
D)  All of the answer choices are correct. 
E)  Borders and color only.

Question 7

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After entering the data below, the modeler would like to enter a formula in cell C5 that can then be copied to cells C6 through C9 without further modification. What formula should be entered in cell C5 to make this possible?

Accepted Answer

A)  =B2*B5 
B)  =B2*$B$5 
C)  =$B$2*B5 
D)  =$B$2*$B$5 
E)  =B2+B5 
A)  =B2*B5 
B)  =B2*$B$5 
C)  =$B$2*B5 
D)  =$B$2*$B$5 
E)  =B2+B5

Question 8

In the example shown below, cell D7 uses absolute reference.

Accepted Answer

A) True 
 B)False

Question 9

An absolute reference changes when it is filled or copied into other cells.

Accepted Answer

A) True 
 B)False

Question 10

A college student is developing a spreadsheet model of a budget. To calculate the monthly surplus (or deficit), the student subtracts living expenses, entertainment costs, and savings from income. Entering which of the following formulas into cell B5 will perform the proper calculation?

Accepted Answer

A)  =Monthly Income − Expenses 
B)  =B1 − B2 − B3 − B4 
C)  =B2 + B3 + B4 − B1 
D)  =B1 + (B2 − B3 − B4) 
E)  =B1 − (B2 − B3 − B4) 
A)  =Monthly Income − Expenses 
B)  =B1 − B2 − B3 − B4 
C)  =B2 + B3 + B4 − B1 
D)  =B1 + (B2 − B3 − B4) 
E)  =B1 − (B2 − B3 − B4)

Question 11

Which of the following is an appropriate first step when building a spreadsheet model?

Accepted Answer

A)  Start with building a small scale model. 
B)  Visualize where you want to finish. 
C)  Test the model. 
D)  Expand the model to full scale. 
E)  Optimize the model. 
A)  Start with building a small scale model. 
B)  Visualize where you want to finish. 
C)  Test the model. 
D)  Expand the model to full scale. 
E)  Optimize the model.

Question 12

Each data value should be entered into how many cells?

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3 
E)  The value should be entered into any formula in which it is needed. 
A)  0 
B)  1 
C)  2 
D)  3 
E)  The value should be entered into any formula in which it is needed.

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

When an analyst uses Solver to find the optimal solution to a problem modeled on a spreadsheet, which step in the modeling process is occurring?

Accepted Answer

A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct. 
A)  Plan. 
B)  Build. 
C)  Test. 
D)  Analyze. 
E)  None of the answer choices are correct.

Question 15

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

Accepted Answer

A)  =$B$9*B10 
B)  =$B$9*C11 
C)  =C10*C11 
D)  =B9*B11 
E)  =$B$10*$B$11 
A)  =$B$9*B10 
B)  =$B$9*C11 
C)  =C10*C11 
D)  =B9*B11 
E)  =$B$10*$B$11

Question 16

Numbers should be included directly in formulas rather than entered separately in data cells in order to keep the spreadsheet model concise.

Accepted Answer

A) True 
 B)False

Question 17

The toggle feature in Excel switches back and forth between viewing formulas and viewing values in the output cells.

Accepted Answer

A) True 
 B)False

Question 18

In the spreadsheet shown below, which of the following is NOT a data cell?

Accepted Answer

A)  Cell B1. 
B)  Cell B2. 
C)  Cell B3. 
D)  Cell B7. 
E)  All of the answer choices are data cells. 
A)  Cell B1. 
B)  Cell B2. 
C)  Cell B3. 
D)  Cell B7. 
E)  All of the answer choices are data cells.

Question 19

A student is using a spreadsheet model to track monthly income and expenses and also to calculate his annual income. After pressing Ctrl+~, the formula view of the spreadsheet (shown below) was visible. What spreadsheet construction error did the student commit?

Accepted Answer

A)  Using an advanced Excel formula instead of a simpler mathematical calculation. 
B)  Entering data in more than one place. 
C)  Failure to adequately use labels to identify cells. 
D)  Incorrect formula. 
E)  There are no errors in the spreadsheet. 
A)  Using an advanced Excel formula instead of a simpler mathematical calculation. 
B)  Entering data in more than one place. 
C)  Failure to adequately use labels to identify cells. 
D)  Incorrect formula. 
E)  There are no errors in the spreadsheet.

Question 20

When developing a new spreadsheet model, it is important to first get a model that works and then to go back later and change the layout so the model is easy to read.

Accepted Answer

A) True 
 B)False

When an analyst enters data into a model to see if the results match expectations, which step of the modeling process is occurring?

Colors and shading can be used to make a spreadsheet model much easier to read and interpret.

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

In the spreadsheet shown below, which of the following is a data cell?

Before building a full-scale version of her spreadsheet model, Julie constructs a smaller version of the spreadsheet. Julie is performing which step of the modeling process?

Which of the following are ways to distinguish data cells, changing cells, output cells, and the objective cell on a spreadsheet?

In the example shown below, cell D7 uses absolute reference.

An absolute reference changes when it is filled or copied into other cells.

A college student is developing a spreadsheet model of a budget. To calculate the monthly surplus (or deficit), the student subtracts living expenses, entertainment costs, and savings from income. Entering which of the following formulas into cell B5 will perform the proper calculation?

Which of the following is an appropriate first step when building a spreadsheet model?

Each data value should be entered into how many cells?

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

When an analyst uses Solver to find the optimal solution to a problem modeled on a spreadsheet, which step in the modeling process is occurring?

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

Numbers should be included directly in formulas rather than entered separately in data cells in order to keep the spreadsheet model concise.

The toggle feature in Excel switches back and forth between viewing formulas and viewing values in the output cells.

In the spreadsheet shown below, which of the following is NOT a data cell?

A student is using a spreadsheet model to track monthly income and expenses and also to calculate his annual income. After pressing Ctrl+~, the formula view of the spreadsheet (shown below) was visible. What spreadsheet construction error did the student commit?

When developing a new spreadsheet model, it is important to first get a model that works and then to go back later and change the layout so the model is easy to read.

Introduction

Linear Programming: Basic Concepts

Linear Programming: Formulation and Applications

What-If Analysis for Linear Programming

Network Optimization Problems

Using Binary Integer Programming to Deal With Yes-Or-No Decisions

Nonlinear Programming

Decision Analysis

Forecasting

Queueing Models

Computer Simulation: Basic Concepts

Computer Simulation With Analytic Solver

Filters

Exam 4: The Art of Modeling With Spreadsheets

When an analyst enters data into a model to see if the results match expectations, which step of the modeling process is occurring?

Colors and shading can be used to make a spreadsheet model much easier to read and interpret.

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

In the spreadsheet shown below, which of the following is a data cell?

Before building a full-scale version of her spreadsheet model, Julie constructs a smaller version of the spreadsheet. Julie is performing which step of the modeling process?

Which of the following are ways to distinguish data cells, changing cells, output cells, and the objective cell on a spreadsheet?

In the example shown below, cell D7 uses absolute reference.

An absolute reference changes when it is filled or copied into other cells.

A college student is developing a spreadsheet model of a budget. To calculate the monthly surplus (or deficit), the student subtracts living expenses, entertainment costs, and savings from income. Entering which of the following formulas into cell B5 will perform the proper calculation?

Which of the following is an appropriate first step when building a spreadsheet model?

Each data value should be entered into how many cells?

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

When an analyst uses Solver to find the optimal solution to a problem modeled on a spreadsheet, which step in the modeling process is occurring?

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

Numbers should be included directly in formulas rather than entered separately in data cells in order to keep the spreadsheet model concise.

The toggle feature in Excel switches back and forth between viewing formulas and viewing values in the output cells.

In the spreadsheet shown below, which of the following is NOT a data cell?

A student is using a spreadsheet model to track monthly income and expenses and also to calculate his annual income. After pressing Ctrl+~, the formula view of the spreadsheet (shown below) was visible. What spreadsheet construction error did the student commit?

When developing a new spreadsheet model, it is important to first get a model that works and then to go back later and change the layout so the model is easy to read.

Introduction

Linear Programming: Basic Concepts

Linear Programming: Formulation and Applications

What-If Analysis for Linear Programming

Network Optimization Problems

Using Binary Integer Programming to Deal With Yes-Or-No Decisions

Nonlinear Programming

Decision Analysis

Forecasting

Queueing Models

Computer Simulation: Basic Concepts

Computer Simulation With Analytic Solver

Filters