University : Griffith University UniLearnO is not sponsored or endorsed by this college or university.
Country : Australia
Assignment Task:

Instructions:
You are an employee of a company selling cars and you have been sent a spreadsheet by another employee who has never used excel before. He is requesting your assistance in formatting this spreadsheet and on showing him how you can use excel to find out specific calculations.

The spreadsheet can be found on moodle entitled “RepeatExcelAssignment2020” and the necessary features you need to use to help your fellow employee are detailed on next page:

1. The spreadsheet should be formatted in a user friendly manner so that it is easy to read and analyse the existing data. It should be clear what each figure represents. Is it money or quantity of Sales?We assume it to be money in thousands. We want to impress your work colleague by making the spreadsheet look professional and attractive to analyse. Format appropriately.

2. Each salesperson has a total but what we need to show the other employee is total sales for each product, the average sales for each product, the lowest sale per product, the highest sale per product and also the number of salespeople selling each product using the countnumbers function. Illustrate these calculations on the spreadsheet ensuring that the values are presented professionally. This must be done using formulae.

3. You have been asked if there is a function that we can use which will automatically categorise the total sales into:
Bonus Sales (if total sales are greater than 6,000,000 per person)
Good Sales (if total sales are greater than 5,000,000 but less than 6000 per person)
Poor Sales (if total sales are less than 5,000,000 per person)

So we should be able to create a function to calculate this for the first salesperson and use autofill to apply it to the rest. Again presentation of this is important. Remember figures in original spreadsheet are in thousands. So 236 in the first cell represents 236,000 euros.

4. The spreadsheet has four worksheets. In the second worksheet entitled “LinkstotalSales” create a linked formula which only shows the totals for all products.

5. The company also has an insurance division and corresponding salespeople plus their sales figures for the year are on the next worksheet entitled “Commission”. Working with the other worksheet entitled” rates” devise a function which will work out the commission for each salesperson. Also, sort the names in the “Commission” worksheet in ascending order as this was requested.

6. Create a suitable chart to show each total product sale from the first worksheet.Make the chart as user friendly as possible showing enough information to make it clear to everyone. In other words, design it well. Place this chart in a new worksheet and name the worksheet appropriately. Set up the spreadsheet so that it can print professionally but dont print it. 


This IT Assignment has been solved by our IT Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : Alex Cerry
  • Posted on : July 15th, 2019
  • Downloads : 394

Whatsapp Tap to ChatGet instant assistance