Using advanced filter and daverage with stock data

[Usc123]

Can someone help me with the following question? I attached the excel file so that you can get a better visual


Use the Advanced Filter and DAverage( ) to calculate the “Average Market Capital”, “Average Current Value” ,
“Average Commission” and “Average Total Cost” for “Large” stocks OR an Earnings Per Share less than $3.
There should be four rows for the “filter Criteria”, name the filter Criteria as “Filter_Criteria_P2Q2”

Note: Make sure the Filter_Criteria_P2Q2 shows in the name manager.