< University of Michigan-Flint MGT 313 Quiz 4 Winter 2015 >

                                Review Test Submission: Q04

                                                Course  Intro To Management Science (Winter 2015)

                                                                                Test Q04

Instructions

Quiz 4 is a timed assessment.

Thirty minutes are allotted for the quiz. While the system will not terminate the quiz after 30 minutes, your grade might be discounted proportionally if you exceed the allotted time.

It is recommended that prior to opening the quiz you assemble:

• Any notes or texts you want for reference

• Pencils, scratch paper and calculator

•A few sheets of graph paper

The latter items might be useful in answering some quantitative questions.

Good luck.

Results Displayed             All Answers, Submitted Answers, Correct Answers

Question 1                                                                                                                                          0 out of 1 points

Important data and formulas can be documented by cell comments.                                     

Question 2                                                                                                                                          0 out of 1 points

Long spreadsheet formulas are desirable because they are sophisticated.                                           

Question 3                                                                                                                                          1 out of 1 points

Spreadsheet model calculations should be placed in a primary location.                                

Question 4                                                                                                                                          0 out of 1 points

Extra time spent in planning can actually reduce the overall time required to perform a spreadsheet analysis.                                    

Question 5                                                                                                                                          1 out of 1 points

While designing a spreadsheet, try to anticipate who will use it and what kinds of questions they will want to address.                                  

Question 6                                                                                                                                          0 out of 1 points

An influence chart doesn’t belong in a model’s workbook.

Question 7                                                                                                                                          0 out of 1 points

User manuals are a practical method of documenting a spreadsheet model.                                       

Question 8                                                                                                                                          1 out of 1 points

Practical methods of documenting a spreadsheet are difficult and time consuming.                        

Question 9                                                                                                                                          0 out of 2 points

To display all formulas in a worksheet                                    

Question 10                                                                                                                                       2 out of 2 points

In a spreadsheet model, modules                                           

Question 11                                                                                                                                       2 out of 4 points

Match the Advertising budget model modules to the picture locations.

Question 12                                                                                                                                       2.64 out of 4 points

Error trapping