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

 (Not rated)
 (Not rated)




                                      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.


    • 6 years ago
    < University of Michigan-Flint MGT 313 Quiz 5 Winter 2015- Answers >

    Purchase the answer to view it

    • attachment