Univ of M-Flint MGT 313 Quiz 4 Winter 2015 with Graded Answers
Review Test Submission: Q04 Course Intro To Management Science (Winter 2015) Test Q04 • Question 1 0 out of 1 points Important data and formulas can be documented by cell comments. Answers: True False • Question 2 0 out of 1 points Long spreadsheet formulas are desirable because they are sophisticated. Answers: True False • Question 3 1 out of 1 points Spreadsheet model calculations should be placed in a primary location. Answers: True False • Question 4 0 out of 1 points Extra time spent in planning can actually reduce the overall time required to perform a spreadsheet analysis. Answers: True False • 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. Answers: True False • Question 6 0 out of 1 points An influence chart doesn’t belong in a model’s workbook. Answers: True False • Question 7 0 out of 1 points User manuals are a practical method of documenting a spreadsheet model. Answers: True False • Question 8 1 out of 1 points Practical methods of documenting a spreadsheet are difficult and time consuming. Answers: True False • Question 9 0 out of 2 points To display all formulas in a worksheet Answers: a. It is impossible to display all formulas in a worksheet. b. Use the formula bar c. Press Shift & Alt simultaneously d. Press CTRL & ~ simultaneously • Question 10 2 out of 2 points In a spreadsheet model, modules Answers: a. are a basic principle of good design b. bring together groups of similar items c. separate unlike items d. all of the items listed e. are a useful first step in organizing information • 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