Question

Complete the following steps in the TysonsStore 2022 worksheet: a. In cell F2, 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 J1. Use an absolute reference where appropriate and copy the formula to cells F3:F32. b. In cell J3, enter a formula to calculate the average daily sales in dollars. c. In cell J4, enter a formula to find the lowest daily sales in dollars. d. In cell J5, enter a formula to find the highest daily sales in dollars.

Answer 1

To complete the specified tasks, formulas for calculating daily totals, and average, minimum, and maximum daily sales are entered into designated cells with appropriate referencing and function usage.

Step-by-step explanation:

To complete the tasks in the TysonsStore 2022 worksheet:

1. In cell F2, enter the formula =E2*$J$1 to calculate the daily total in dollars by multiplying the number of boxes sold (assumed to be in column E, since 'Daily Total (# Sold)' is mentioned but not located) with the price per box in cell J1. Ensure that you use absolute referencing for cell J1 by adding dollar signs ('$') before the column letter and row number. This keeps the reference to the price per box constant when copying the formula down to cells F3:F32.
2. To calculate the average daily sales in dollars in cell J3, enter the formula =AVERAGE(F2:F32).
3. For the lowest daily sales in dollars, enter the formula =MIN(F2:F32) in cell J4.
4. To find the highest daily sales in dollars, enter the formula =MAX(F2:F32) in cell J5.

Answer 2

To complete the TysonsStore 2022 worksheet, follow the steps below.

Step-by-step explanation:

To complete the steps in the TysonsStore 2022 worksheet:

a. In cell F2, enter the formula =Daily Total (# Sold) * $J$1 to calculate the daily total in dollars. Use an absolute reference for the price per box in cell J1. Copy the formula to cells F3:F32.

b. In cell J3, enter the formula =AVERAGE(F2:F32) to calculate the average daily sales in dollars.

c. In cell J4, enter the formula =MIN(F2:F32) to find the lowest daily sales in dollars.

d. In cell J5, enter the formula =MAX(F2:F32) to find the highest daily sales in dollars.