Show the sales for a product, Business Management

Assignment Help:

a) Copy the sales data provided on the VLE into a separate worksheet within your Garden workbook and call it Sales Database. Sort this data into sales for each month in 2010 and show a subtotal of the sales for each month. Use these subtotals to produce a bar chart for total monthly sales during 2010.

b) Sort the data into Sales by Product and create a sub total for quantity of each sold. Produce a pie chart to represent the sales of each garden extra.

c) Add a filter to show the sales for a particular product selected by the user.

d) You should be able to see which product has sold the most and which the least, Use the MIN and Max functions to confirm your view, and to display which product has sold the most and which the least. (VLOOKUP will be required)


Related Discussions:- Show the sales for a product

Business and cultural, Judge how the business and cultural environments sha...

Judge how the business and cultural environments shape the behaviour of a selected organisation

Unit 3 Report, Ask questioYou may use two (2) quotes in your report, each n...

Ask questioYou may use two (2) quotes in your report, each no more than one sentence in length. Ensure your report meets all of the following criteria: A minimum of 700 words– your

Employee or customer safety, Employee or Customer Safety: Worn out equipme...

Employee or Customer Safety: Worn out equipment is likely to fail at any moment and these failures can cause injuries to the workers working on those equipments. Products such

Significant provisions for employee working hours, What are the important p...

What are the important provisions for employee working hours? Working Hours: The provisions relating to working hours deal along with the given factors: a. Weekly hour

Customer barganning power, does gender has any influence on customer bargai...

does gender has any influence on customer bargaining power?

Electronic purchase orders, QUESTION 1 (a) Requirements engineering is ...

QUESTION 1 (a) Requirements engineering is the process of discovering, documenting and maintaining a set of requirements for a computer - based system. What are requirements?

Leadership consists, Leadership consists: Leadership happens when peop...

Leadership consists: Leadership happens when people push, cajole, and influence others to work towards the achievement of a specific objective. That distinguishes leadership w

Define the major classes of risk an organization, What are the four major c...

What are the four major classes of risk an organization evaluates while outsourcing? Explain them. 1. Strategic risks. 2. Operational risks. 3. Result risks. 4. Transac

Management skills, Management skills: Q. A few organizations have rece...

Management skills: Q. A few organizations have recently tried to minimize employee use of email when communicating with colleagues. Specifically, these companies have banned t

#title.public procurement, what are the main objectives of the procurementA...

what are the main objectives of the procurementAct 2006

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd