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

How will an investor earn risk less arbitrage, Question: 1. What factor...

Question: 1. What factors might an individual investor take into account in determining her or his investment policy? 2. Distinguish between fundamental and technical securi

The use of var for capital requirement for market risk, Question 1 Identif...

Question 1 Identify and assess the different IRR measurement techniques implemented in a bank Question 2 Describe the use of VaR for capital requirement for market risk Ques

Naughty Rule, Ask question “Naughty Rule”#Minimum 100 words accepted#

Ask question “Naughty Rule”#Minimum 100 words accepted#

Managerail economics, Using the case study approach,discuss the significanc...

Using the case study approach,discuss the significance of managerial economics in regard to business strategies employed by business entities currently operating in the global econ

DORIC CONVERSION TECHNOLOGIES, Explain the ethical issues from Peter Johns...

Explain the ethical issues from Peter Johnson''s point of view.

Name and explain negative aspects/outcomes of team work, QUESTION 1 (a...

QUESTION 1 (a) List down and explain 2 main and distinct strategies you would adopt to settle a given conflict in your organisation. (b) Name and explain clearly 2 positive

Differences, Difference between selling concept & marketing conceptt

Difference between selling concept & marketing conceptt

What are the types of participation worker, What are the types of participa...

What are the types of participation worker? Types of Worker’s Participation are as follows: Worker’s participation into management may take several forms, for example:

Briefly explain the main categories of e-commerce, QUESTION 1 (i) ‘Netw...

QUESTION 1 (i) ‘Networking technologies have drastically changed the way organisations operate'. Distinguish between a Wide Area Network (WAN) and a Local Area Network (LAN) an

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