Question

Using excel, answer the following questions. Write down the Excel formulas used at each step.1. General Junkfoods has collected data on the last 10,000 boxes of cereal they produced.a. What is the average weight of a box of their cereal

Answer 1

See explanation

Explanation:

Required

The average weight produced

The question is incomplete, as the required cells are not given and there are other missing details.

However, I will give a general explanation of calculating average in Excel

The required formula is:

=AVERAGE(Cell Range)

Assume the cells that contain the boxes are: cells A10 to A10010

The average will be calculated as:

=AVERAGE(A10:A10010)