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

                                      Review Test Submission: Q05

                                                                Course  Intro To Management Science (Winter 2015)

                                                                                                Test Q05

Instructions        Quiz 5 is a timed assessment.

Thirty minutes are allotted for the quiz.

While the system will not terminate the quiz after 30 minutes, your grade 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                                                                                                                                          2 out of 2 points

Two factors - the sample size and the amount of variation in the population - influence sampling error.

Question 2                                                                                                                                          2 out of 2 points

An Excel database is a list file with the first row comprised of field names and the remaining rows containing records.                                    

Question 3                                                                                                                                          2 out of 2 points

Pivot tables cannot be modified easily after they are built                                           

Question 4                                                                                                                                          0 out of 2 points

The form tool is useful for searching and editing an Excel database.                        

Question 5                                                                                                                                          3 out of 3 points

In an Excel database, a row is called a

Question 6                                                                                                                                          3 out of 3 points

The database Applicants.xlsx describes an MBA applicant pool. The first row contains field names. Rows 2 - 2918 contain applicant data. Columns J and K are DECISION and GMAT respectively. The database is selected and filtered with only enrolling applicants showing. To calculate the average GMAT score of enrolling applicants use the expression                                    

Question 7                                                                                                                                          3 out of 3 points

To produce the following pivot table for the Applicants database (Rows are Application Rounds)

Add the fields to the Pivot Table areas.                                 

Question 8                                                                                                                                          3 out of 3 points

You have selected the Dish database and entered the following information into Find and Replace.