(1) fill in the gray cells in terms of the information in the same row in tab Q3. For example, the first gray cell is to calculate the total sales.

(2) fill in the orange cells according to the value of sales, if the sales is above 40 mark high; if between 30 and 40(include) mark mid; if below 30(include) mark low.

(apply functions)