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

profiletruecolors
 (Not rated)
 (Not rated)
Chat

 

 

 

                                      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 >
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      university_of_michigan-flint_mgt_313_quiz_5_winter_2015.docx