Show the sales for a product, Business Management

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)

Posted Date: 3/25/2013 1:57:11 AM | Location : United States







Related Discussions:- Show the sales for a product, Assignment Help, Ask Question on Show the sales for a product, Get Answer, Expert's Help, Show the sales for a product Discussions

Write discussion on Show the sales for a product
Your posts are moderated
Related Questions
10. State Z’s automobile manufacturing industry is one of the largest and most highly regarded in the world. The industry is concerned that it may lose some of its domestic market

mention 5 measures that will make a dis pleased customer patronize the school canteen

hi there, I just need an assignment to be ready

Question: There is no one specific method of categorizing organization theories. Thus, it is generally accepted that: (a) The Type 1 theorists, also known as the classical s

Evaluate the importance of business processes in delivering outcomes based upon business goals and objectives. a. How would you classify the GE culture in terms of the "Handy Mo

Hi I am Nelson Daniels I am checking up on my Ticket ID EM13830601 I see my payment has been authorized I need help on my 5.5 - Research Exercise: Microsoft Dynamics Research Rep

A) Define what is meant by Option Valuation for IS investments. Outline what is aims to achieve. B) Briefly discuss the observation that incremental innovations favour the incum

QUESTION 1 People are one of the most important resources in an organization. Consequently, one of the main functions of the human resource manager is to ensure that the organi

The phase consists of the followings activates: 1. Identify the core high level processes, 2. Recognize potential change enablers, 3. Gather performance metric withi