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

Office administration, how to draw a stock control card and discuss the com...

how to draw a stock control card and discuss the completion process .

Explain the importance of good communication, Question 1: (a) Explain t...

Question 1: (a) Explain the importance of good communication in your organisation or in any organisation of your choice. (b) Describe the major barriers to good communicati

Impacting upon intercultural communication, QUESTION 1 Distinguish betw...

QUESTION 1 Distinguish between the three broad theoretical frameworks that attempt to provide an explanation and understanding of communication and culture. QUESTION 2

Project, critical evaluation of CSR activities of Oracle?

critical evaluation of CSR activities of Oracle?

Kanban system, Kanban System  The work kanban literally means visual re...

Kanban System  The work kanban literally means visual record usually kanban is loosely referred to as a card system. Kanban is the production control system that pulls JIT prod

IT, #questionExplain the changes in recent years in society, especially wit...

#questionExplain the changes in recent years in society, especially with regard to in technology usage, as it relates to the steady increase in; available computing power, availabl

Business model and designing a web strategy, Creating a New Internet Busine...

Creating a New Internet Business Here is a list of new businesses that could benefit from using the Web, listed. Select one of the businesses from this list and develop an Inte

What is free rein or laissez faire in leadership, What is free rein or lais...

What is free rein or laissez faire in leadership? Free Rein or Laissez Faire: • Leadership leaves subordinates completely to themselves for task achievement. • Exercis

Describe ebay activities, Question: A firm's connected activities are d...

Question: A firm's connected activities are defined as those activities that the firm must perform in order to deliver its customer value. A firm's strategy is said to be sound

How listening plays an important role in the communication, QUESTION a...

QUESTION a) Describe the different barriers which prevent effective listening in organisations and explain in detail each of those barriers while at the same time provide solu

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