Reference no: EM133172765

As a qualified BAS Agent, you have been asked by one of your newly acquired clients, Mr Xavier Samuel to assist him with his business. He wants to keep a spreadsheet for each month's sales. He has five sales staff and would like to record the daily sales figure. He wants to see a monthly total for each person and a daily sales total. He would also like an average daily sale, the lowest sales figure, and the highest sales figure for each day. The data should have highlighted to show figures below the daily average and figures above the average. There should be a separate worksheet that shows a commission figure for each salesperson daily. He pays each person a flat 15% of everything they sell as a commission. Mr Samuel thinks a template for the above spreadsheet would help him because he will create a new spreadsheet every month. Then he would like a master spreadsheet that shows each person's monthly sales figure. He would like to have an annual total for each and a grand total. He would like a chart showing each person my month and another chart that shows each person's annual sales figure as a part of the total sales figure. Mr Samuel has provided you with January's sales figures for each staff member to input into your spreadsheet as follows.

Layout instructions for Part C:

• Create the series of spreadsheets using the excel workbook provided in your student pack.
• The first sheet of your Excel Workbook must include your name and student number.
• Name each sheet appropriately on each tab and headings.
• Include a header on each sheet with your name and student number.