< University of Michigan-Flint MGT 313 Quiz 5 Winter 2015 >truecolors
Review Test Submission: Q05
Course Intro To Management Science (Winter 2015)
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.
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 modiﬁed 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
Purchase the answer to view it