I need answers in excel formula.

In cell F$2,$ enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total $($# Sold$)$ column by the current price per box in cell K$1.$ Use an absolute reference where appropriate and copy the formula to cells F$3$:F$32.$

In cell G$2,$ enter a formula using the IF function to determine whether the daily sales goal in cell K$2$ was met. Display yes if the value in the Daily Total $($$$)$ column is greater than or equal to the daily sales goal. Display no if it is not. Use an absolute reference where appropriate and copy the formula to cells G$3$:G$32.$

Create a named range DailyTotals for cells F$2$:F$32.$

In cell K$3,$ enter a formula using the named range DailyTotals to calculate the average daily

sales in dollars.

In cell K$4,$ enter a formula using the named range DailyTotals to find the lowest daily sales

in dollars.

In cell K$5,$ enter a formula using the named range DailyTotals to find the highest daily sales

in dollars.