(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) 

1 2 3 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 B area A B A B C A B C A C A B C B C A B total sales volumn number of records of pear number of records when sales