Review Test Submission: Q05 Course Intro To Management Science (Winter 2015)Test Q05 Question 12 out of 2 points Two factors – the sample size and the amount of variation in the population – influence sampling error. Answers: True False Question 22 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. Answers: True False Question 32 out of 2 points Pivot tables cannot be modi?ed easily after they are built Answers: True False Question 40 out of 2 points The form tool is useful for searching and editing an Excel database. Answers: True False Question 53 out of 3 points In an Excel database, a row is called a Answers: a.Variable b.None of the other names listed here c.Field d.Record Question 63 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 Answers: a.=subtotal(average,K2:K2918) b.None of the other expressions listed here c.=subtotal(1,K2:K2918) d.=average(K2:2918) Question 73 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 83 out of 3 points You have selected the Dish database and entered the following information into Find and Replace. Clicking the Replace All button will Review Test Submission: Q05 Course Intro To Management Science (Winter 2015)Test Q05 Question 12 out of 2 points Two factors – the sample size and the amount of variation in the population – influence sampling error. Answers: True False Question 22 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. Answers: True False Question 32 out of 2 points Pivot tables cannot be modi?ed easily after they are built Answers: True False Question 40 out of 2 points The form tool is useful for searching and editing an Excel database. Answers: True False Question 53 out of 3 points In an Excel database, a row is called a Answers: a.Variable b.None of the other names listed here c.Field d.Record Question 63 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 Answers: a.=subtotal(average,K2:K2918) b.None of the other expressions listed here c.=subtotal(1,K2:K2918) d.=average(K2:2918) Question 73 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 83 out of 3 points You have selected the Dish database and entered the following information into Find and Replace. Clicking the Replace All button will