Question

In cell k3, enter a formula using the named range dailytotal to calculate the average daily sales in dollars.

Options:
a) =AVERAGE(DailyTotal)
b) =AVERAGE(K3:DAILYTOTAL)
c) =AVERAGE(K3:DailyTotal)
d) =AVERAGE(DAILYTOTAL:K3)

Answer 1

The correct formula to calculate the average daily sales using the named range 'dailytotal' is =AVERAGE(DailyTotal).

Step-by-step explanation:

The correct formula to calculate the average daily sales in dollars using the named range 'dailytotal' and entering it in cell K3 is =AVERAGE(DailyTotal).

This formula uses the AVERAGE function to calculate the average of the numbers in the named range 'dailytotal', which represents daily sales values. By entering this formula in cell K3, the average daily sales in dollars will be displayed.