On the DailyTransactions worksheet, create an advanced filter to explore the data by completing the following. Copy the column headers in A$10$:F$10$ and paste them at the top of the sheet, starting in cell A$1.$

Add the appropriate criteria so that only transactions from the Food category that was purchased on a Friday are displayed. Copy the filtered results, including the column headings, and paste them on the DailyTransactionFilter worksheet, starting in cell A$1.$

On the DailyTransactions worksheet, use database functions to explore the data by completing the following. Clear the advanced filter. Create a DailyDatabase named range on the range A$10$:F$40.$

In cell B$5,$ type QtySold as the field to use in the calculations.

In cell B$6,$ enter a DSUM function that will calculate the total QtySold for records that meet the specified criteria.$$

In cell B$7,$ enter a DAVERAGE function that will calculate the average QtySold for records that meet the specified criteria.