2024 < University of Michigan-Flint MGT 313 Quiz 2 Winter 2015 > Assignment Help
Review Test Submission Q02 Course Intro To Management Science Winter 2015 Test Q02 Instructions Quiz 2023
Review Test Submission: Q02 Course Intro To Management Science (Winter 2015) Test Q02 Instructions Quiz 2 is a timed assessment. Thirty minutes are allotted for the quiz. While the system will not terminate the quiz after 30 minutes, your grace 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 The Home ► Editing ► Fill ► Series command will enter various kinds of se ries. Question 2 1 out of 1 points The Office Building Planning model concerns floor plans of a new office building. 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. 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. Question 5 2 out of 2 points Each Excel file is called a 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(_______). Question 13 0 out of 0 points On my honor, I completed this quiz individually, without assistance from any other person(s).