< University of Michigan-Flint MGT 313 Quiz 2 Winter 2015 >

                                                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 series.                                   

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 first 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).