Exam 16: Spreadsheet Modeling: an Introduction

Explore all topics

You can insert __________________ for a cell to add explanatory information about a calculation or assumption that does not have to be in the model itself.

(Multiple Choice)

4.8/5

(38)

Question 101

Absolute references do _____________ change when you copy them.

(Short Answer)

4.7/5

(27)

Question 102

Once you run Goal Seek in Excel, you cannot revert back to the original values.

(True/False)

4.8/5

(29)

Question 103

In Excel, relative references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

(True/False)

4.9/5

(40)

Question 104

Models transform inputs into ________________________

(Short Answer)

4.9/5

(29)

Question 105

In Excel, you can copy text labels by using the:

(Multiple Choice)

4.9/5

(45)

Question 106

What Excel feature works backwards to find the value of an input quantity that causes an output quantity to have a particular value?

(Multiple Choice)

4.7/5

(41)

Question 107

In the custom footer box, there is a button to automatically insert the page number.

(True/False)

4.8/5

(33)

Question 108

In Excel, Goal Seek is found under which menu option?

(Multiple Choice)

4.9/5

(28)

Question 109

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

(Short Answer)

4.7/5

(42)

Question 110

In Excel, which function returns the number of cells containing numerical values?

(Multiple Choice)

4.8/5

(39)

Question 111

Data tables perform ___ what-if _ quickly and easily.

(Short Answer)

4.8/5

(33)

Question 112

How do you know that you have a relative reference in Excel?

(Short Answer)

4.8/5

(35)

Question 113

What are the six steps to developing an effective spreadsheet model?

(Essay)

4.9/5

(40)

Question 114

In the Excel MATCH function, which argument is the value that we want to test?

(Multiple Choice)

4.9/5

(40)

Question 115

In Excel, the command to print Cell Comments is selected under which menu/submenu?

(Multiple Choice)

4.8/5

(43)

Question 116

Which of the following is a means of implementing mathematical models?

(Multiple Choice)

4.7/5

(43)

Question 117

Sometimes the things you learn about the real situation during the modeling process are even more important than the numerical results of the model.

(True/False)

4.9/5

(38)

Question 118

What is a primary reason why recommended footers contain the date and time?

(Short Answer)

4.9/5

(31)

Question 119

In a spreadsheet, it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

(True/False)

4.8/5

(38)

Question 120

Showing 101 - 120 of 137

You can insert __________________ for a cell to add explanatory information about a calculation or assumption that does not have to be in the model itself.

Absolute references do _____________ change when you copy them.

Once you run Goal Seek in Excel, you cannot revert back to the original values.

In Excel, relative references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Models transform inputs into ________________________

In Excel, you can copy text labels by using the:

What Excel feature works backwards to find the value of an input quantity that causes an output quantity to have a particular value?

In the custom footer box, there is a button to automatically insert the page number.

In Excel, Goal Seek is found under which menu option?

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

In Excel, which function returns the number of cells containing numerical values?

Data tables perform ___ what-if _ quickly and easily.

How do you know that you have a relative reference in Excel?

What are the six steps to developing an effective spreadsheet model?

In the Excel MATCH function, which argument is the value that we want to test?

In Excel, the command to print Cell Comments is selected under which menu/submenu?

Which of the following is a means of implementing mathematical models?

Sometimes the things you learn about the real situation during the modeling process are even more important than the numerical results of the model.

What is a primary reason why recommended footers contain the date and time?

In a spreadsheet, it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Exam 16: Spreadsheet Modeling: an Introduction

You can insert __________________ for a cell to add explanatory information about a calculation or assumption that does not have to be in the model itself.

Absolute references do _____________ change when you copy them.

Once you run Goal Seek in Excel, you cannot revert back to the original values.

In Excel, relative references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Models transform inputs into ________________________

In Excel, you can copy text labels by using the:

What Excel feature works backwards to find the value of an input quantity that causes an output quantity to have a particular value?

In the custom footer box, there is a button to automatically insert the page number.

In Excel, Goal Seek is found under which menu option?

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

In Excel, which function returns the number of cells containing numerical values?

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

How do you know that you have a relative reference in Excel?

What are the six steps to developing an effective spreadsheet model?

In the Excel MATCH function, which argument is the value that we want to test?

In Excel, the command to print Cell Comments is selected under which menu/submenu?

Which of the following is a means of implementing mathematical models?

Sometimes the things you learn about the real situation during the modeling process are even more important than the numerical results of the model.

What is a primary reason why recommended footers contain the date and time?

In a spreadsheet, it is better to write a smaller number of more complex formulas than to write a larger number of simple formulas.

Introduction to Operations Management

Operations Strategy and Competitiveness

Product Design and Process Selection

E-Commerce and Supply Chain Management

Total Quality Management

Statistical Quality Control

Just-In-Time and Lean Systems

Forecasting

Capacity Planning and Facility Location

Facility Layout

Work System Design

Independent Demand Inventory Management

Aggregate Planning

Resource Planning

Scheduling

Project Management

Spreadsheet Modeling: an Introduction

Waiting Line Models

Master Scheduling and Rough-Cut Capacity Planning

Filters

Data tables perform ___ what-if _ quickly and easily.