Question: Question 3: Querying a Table and Data Extraction (10 points) We need your help to complete the missing parts of this worksheet for company X

 Question 3: Querying a Table and Data Extraction (10 points) We

Question 3: Querying a Table and Data Extraction (10 points) We need your help to complete the missing parts of this worksheet for company X shareholders 1) Formula 1 represents the Grade for each person. The Grade depends on the % of Share the person achieved. Use the table on the right to extract the Grade for each fund raiser. 2) Formula 2 and 3 represent the average Experience for Full Time members and average Share for Part Time members. Use one database and one statistical function to calculate them. (Notice the criterion in the figure above). - Formula 2: - Formula 3: 3) Formula 4 represents the number of people who have Grade A that is shown in column F. 4) Using Advanced Filtering query, we want to extract the records for those who are either: full time with over 7 years of experience, or part time with 4 and above years of experience. Where and what's the criteria you would write for that, in the upper area of the worksheet

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!