Remove the table functionality from the table. Do this in a way that leaves the formatting intact.

Use a function to make K$4$ show the total number of pies sold on Monday.

Use a function to make K$5$ show the average number of Pecan Pies sold throughout the week.

Move the chart to a new chart worksheet called Lemon Meringue Sales.

Apply a setting to C$4$:G$15$ that formats all values $15$ and lower as Light Red Fill with Dark Red Text. When completing this task, use a method that requires you to choose Light Red Fill with Dark Red Text from a dropdown.