Question details

Draw a column chart that shows the top five selling items based on annual sales
$ 15.00

Now you are supposed to use one of non routine experimentation skill to work on this assignment as following:

Suppose your boss give you an excel file ( see the attachment), and ask you to

1) fill in the blanks to the cells with pink highlights

2) draw a column chart that shows the top five selling items based on annual sales

Hints: 1) You are only asked to write some simple functions according to the given information, for example, as a future business professional, you are supposed to know how to calculate the annual sales after you are given unit sales price and average unit sales (=unit sales price * average unit sales), you are supposed to know how to use functions to find the lowest annual sales, average, or highest annual sales , and Gross Margin Per Unit means the difference between unit sales price and unit cost.

Available solutions