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 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
Get step-by-step solutions from verified subject matter experts
