D E Title Gender F B 1 Name Location 2 Rubin Boston 3 Smith Atlanta 4 Johnson Chicago 5 Marder Chicago 6 Manin Boston M Account Rep Account Rep Manager Trainee Account Rep Hire Date Service Salary 3/16/2004 14.2 $45,000 1/14/2001 17.4 $65,000 10/31/2000 17.6 $47,500 6/15/2000 18.0 $38,500 3/16/1999 19.3 $49,500 M F F Based on above table (figure 1), you need to find out the average salary of employees living in Boston and name starting from M (using criteria range and database formula). One of the students answers this question as follows (see figure 2 - criteria range and formula). Choose the correct multiple choice answer provided below based on Figure 2. Note: Both the original table (above) and the criteria range (below) are in the same worksheet for this question. D E G Title Gender Hire Date Service Salary Figure 2: A B 8 Name Location 9 M? Boston 10 11 Formula Used =DAVERAGE(A1:G6, A1, A8:59) Note: If you want to open an excel file similar to this and TYPE your formula to answer this question, you can do that that. Please click Practice file for Quiz 3-1.xlsx and work on that excel file to answer this question (same file will be used through this quiz - no need to download the excel file everytime, if you have already downloaded it once). Conditions given on Criteria range (Row 9) is correct in Figure 2