Review Test Submission: Q04Course Intro To Management Science (Winter 2015)Test Q04 Question 10 out of 1 points Important data and formulas can be documented by cell comments. Answers: True False Question 20 out of 1 points Long spreadsheet formulas are desirable because they are sophisticated. Answers: True False Question 31 out of 1 points Spreadsheet model calculations should be placed in a primary location. Answers: True False Question 40 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 51 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 60 out of 1 points An influence chart doesnt belong in a models workbook. Answers: True False Question 70 out of 1 points User manuals are a practical method of documenting a spreadsheet model. Answers: True False Question 81 out of 1 points Practical methods of documenting a spreadsheet are difficult and time consuming. Answers: True False Question 90 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 102 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 112 out of 4 points Match the Advertising budget model modules to the picture locations. Question 122.64 out of 4 points Error trappingReview Test Submission: Q04Course Intro To Management Science (Winter 2015)Test Q04 Question 10 out of 1 points Important data and formulas can be documented by cell comments. Answers: True False Question 20 out of 1 points Long spreadsheet formulas are desirable because they are sophisticated. Answers: True False Question 31 out of 1 points Spreadsheet model calculations should be placed in a primary location. Answers: True False Question 40 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 51 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 60 out of 1 points An influence chart doesnt belong in a models workbook. Answers: True False Question 70 out of 1 points User manuals are a practical method of documenting a spreadsheet model. Answers: True False Question 81 out of 1 points Practical methods of documenting a spreadsheet are difficult and time consuming. Answers: True False Question 90 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 102 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 112 out of 4 points Match the Advertising budget model modules to the picture locations. Question 122.64 out of 4 points Error trapping