Use DAVERAGE to summarize customer survey data.

Click the Average Ratings worksheet tab and select cell B$5.$

Click the Insert Function button $[$Formulas tab, Function Library group$].$

Scroll through the list of functions to find the Database category.

Select DAVERAGE and click Insert Function in the Formula Builder to calculate an average comfort rating for the boots.

Choose Survey for the Database argument.

Click the Field box, select cell B$4,$ and create a mixed reference B$$4.$

Click the Criteria box, select the Criteria sheet tab, select cells A$1$:A$2,$ and make the references absolute $($Figure $6-100).$

DAVERAGE for comfort rating

Figure $6-100$ MAC DAVERAGE for comfort rating

Click Done. The result is $7\mathrm{.}75.$

Copy the formula in cell B$5$ to cells C$5$:D$5.$