Finally, Camille wants to calculate the average ad amount for the Social media channel. In cell H$12,$ create a formula using the DAVERAGE function to average the ad amounts for the Social media channel, using a structured reference to all the columns in the AdLookup table $($range A$1$:E$36)$ as the database, $"$Ad Amr" as the field, and the range G$10$:G$11$ as the criteria.

X Create a formula using a function.

In the Ad Lookup worksheet, the formula in cell H$12$ should contain the DAVERAGE function.