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

non verbal communication, Describe three specific situations at the workpl...

Describe three specific situations at the workplace where positive non verbal communication could be used effectively to enhance verbal communication.

How can you improve your listening skills, QUESTION We spend a major po...

QUESTION We spend a major portion of our time either transmitting or receiving information. Research has shown that we spend 45% of all our communicating time listening. Since

Using an evaluation framework, QUESTION 1 Using an Evaluation Framework...

QUESTION 1 Using an Evaluation Framework, assess the past and ongoing contribution of foreign firms in the Mauritian Export Processing Zone QUESTION 2 Protectionism is

Help, Can I work here as assignment writer?

Can I work here as assignment writer?

Briefly describe the four key drivers of e-commerce, QUESTION 1 (a) How...

QUESTION 1 (a) How is groupware different from other types of software? (b) Illustrate and describe in detail the Computer Supported Cooperative Work (CSCW) matrix QUEST

Global economic crises, Global Economic Crises                     Th...

Global Economic Crises                     The current economic crisis has affected many countries in Europe as well as many countries in the world over. Micro credit institu

Illustrate the term accounting, Illustrate the term accounting? Accou...

Illustrate the term accounting? Accounting: It is an art of classifying and recording data. Here, the data considers to transactions consisting of monetary or financial v

Describe the communication process, Question: "Presenters, especially s...

Question: "Presenters, especially scientists, seem to have jumped onto the "PowerPoint" bandwagon, and are using visual aids throughout their presentation - from the title slid

Useful of Management in business sectors, Management is Really useful fo...

Management is Really useful for decesion making if your statement is true then comment !how?

How you would proceed to select a manager for organization, Question: I...

Question: In this period of shortage of talent, (a) The selection exercise is becoming more and more demanding. Explain with details as to how you would proceed to select a

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