Univ of M-Flint MGT 313 Quiz 2 Winter 2015.docx
Review Test Submission: Q02 Course Intro To Management Science (Winter 2015) Test Q02 • Question 1 0 out of 1 points The Home?Editing?Fill?Series command will enter various kinds of series. Answers: True False • Question 2 1 out of 1 points The Office Building Planning model concerns floor plans of a new office building. Answers: True False • Question 3 1 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 4 1 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 5 2 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 6 0 out of 2 points How many built-in functions does Excel have? • Question 7 0 out of 2 points =IF(“A” = “a”,1,0) evaluates to _____ • Question 8 0 out of 2 points =IF(5>= 8,average(6,7),min(5,10)) evaluates to _____ • Question 9 2 out of 2 points If the contents of C4 were copied and pasted to C11, the numerical value in C11 would be _____ • Question 10 2 out of 2 points If the contents of C4 were copied and pasted to B11, the numerical value displayed in B11 would be _____. • Question 11 0 out of 2 points If the contents of C4 were copied and pasted to D13, the address in D13 would be _____. • Question 12 0 out of 2 points To find the NPV of the cash flows @ discount rate shown, use the expression = C6 + NPV(_______).