Review Test Submission: Q02 Course Intro To Management Science (Winter 2015)Test Q02 Question 10 out of 1 points The Home?Editing?Fill?Series command will enter various kinds of series. Answers: True False Question 21 out of 1 points The Office Building Planning model concerns floor plans of a new office building. Answers: True False Question 31 out of 1 points To select two distinct rectangles of cells, select the ?rst range, hold down the Control key, and select the second range. Answers: True False Question 41 out of 1 points One way to edit the information in a cell is to place the cursor on the cell and press F2. Answers: True False Question 52 out of 2 points Each Excel file is called a Answers: 1.tab 2.cell 3.range 4.none of the other names listed 5.workbook 6.sheet Question 60 out of 2 points How many built-in functions does Excel have? Question 70 out of 2 points =IF(A = a,1,0) evaluates to _____ Question 80 out of 2 points =IF(5>= 8,average(6,7),min(5,10)) evaluates to _____ Question 92 out of 2 points If the contents of C4 were copied and pasted to C11, the numerical value in C11 would be _____ Question 102 out of 2 points If the contents of C4 were copied and pasted to B11, the numerical value displayed in B11 would be _____. Question 110 out of 2 points If the contents of C4 were copied and pasted to D13, the address in D13 would be _____. Question 120 out of 2 points To find the NPV of the cash flows @ discount rate shown, use the expression = C6 + NPV(_______). Review Test Submission: Q02 Course Intro To Management Science (Winter 2015)Test Q02 Question 10 out of 1 points The Home?Editing?Fill?Series command will enter various kinds of series. Answers: True False Question 21 out of 1 points The Office Building Planning model concerns floor plans of a new office building. Answers: True False Question 31 out of 1 points To select two distinct rectangles of cells, select the ?rst range, hold down the Control key, and select the second range. Answers: True False Question 41 out of 1 points One way to edit the information in a cell is to place the cursor on the cell and press F2. Answers: True False Question 52 out of 2 points Each Excel file is called a Answers: 1.tab 2.cell 3.range 4.none of the other names listed 5.workbook 6.sheet Question 60 out of 2 points How many built-in functions does Excel have? Question 70 out of 2 points =IF(A = a,1,0) evaluates to _____ Question 80 out of 2 points =IF(5>= 8,average(6,7),min(5,10)) evaluates to _____ Question 92 out of 2 points If the contents of C4 were copied and pasted to C11, the numerical value in C11 would be _____ Question 102 out of 2 points If the contents of C4 were copied and pasted to B11, the numerical value displayed in B11 would be _____. Question 110 out of 2 points If the contents of C4 were copied and pasted to D13, the address in D13 would be _____. Question 120 out of 2 points To find the NPV of the cash flows @ discount rate shown, use the expression = C6 + NPV(_______).