### 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.

### Solutions

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

Draw

Submitted on: 31 Jan, 2018 03:55:29 This tutorial has not been purchased yet .
Attachment: ass4_fl14.zip