Question

In Excel, what Excel function can be used in cell A29 on the Profits worksheet to calculate the average costs of cookie dough flavors?

a) =SUM(Cost)
b) =AVERAGE(Cost)
c) =AVG(Cost)
d) =TOTAL(Cost)

Answer 1

In Excel, the function to calculate the average costs of cookie dough flavors in cell A29 would be =AVERAGE(Cost). This assumes that 'Cost' is the range where the costs are listed. Other options like =SUM, =AVG, or =TOTAL are incorrect for calculating averages.

Step-by-step explanation:

In Excel, to calculate the average costs of cookie dough flavors in cell A29 on the Profits worksheet, you would use the =AVERAGE function. Specifically, the correct syntax would be =AVERAGE(Cost) if 'Cost' is the name of the range that contains the cost values. This function adds up all the numbers in the specified range and then divides by the count of those numbers to yield the average.

Neither =SUM(Cost), =AVG(Cost), nor =TOTAL(Cost) would provide the average; the =SUM function only adds up the numbers without averaging them, =AVG is not a valid Excel function, and =TOTAL is not a standard Excel function for calculating averages.