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

Explain the role of communication in conflicting situations, QUESTION 1 ...

QUESTION 1 Explain what you understand by the term "Feedback" and how this can help in improving communication in our work place environment. QUESTION 2 Who are organisati

Test marketing & FMCG, explain the various approaches that are followed by ...

explain the various approaches that are followed by FMCG companies in test marketing

Functional and process management, How will officers achieve intergration w...

How will officers achieve intergration when they have no authority over either the administrative functions or programs

Improve industrial relations in the company, Question: (a) You have bee...

Question: (a) You have been appointed as the Human Resource Manager of BPO Ltd and the Chief Executive Officer has requested you to propose measures to improve industrial relat

Policies about ethical behavior and ideas, Policies about Ethical Behavior ...

Policies about Ethical Behavior and Ideas This company has global code of conduct that reflects its ethical behavior and ideas. In global code of conduct, the company include

What do you mean by total in total quality management, What do you mean by ...

What do you mean by total in total quality management? Total in Total Quality Management: It is stands for an overall integrated approach to all features of quality, all

Reseach nuclear energy from a global perspective., how can one examing this...

how can one examing this industry from a global perspective without getting plagiarism.

Cultural context, Problem 1 a) What do you meant by cultural context? ...

Problem 1 a) What do you meant by cultural context? b) Differentiate between low-context cultures and high-context cultures. c) How will we improve intercultural commu

How does a resume affect your employability, Question 1 There are various ...

Question 1 There are various techniques of reading out of which SQ3R is most popular. How will you apply it while reading and research? Question 2 Advertisements are used by

Describe the rights and duties of the banker, QUESTION (a) In the banke...

QUESTION (a) In the banker-customer contractual relationship, each party has some rights and duties. Describe the rights and duties of both the banker and the customer, quoting

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