Produce Spreadssheets er 2017 ICAICT205A-BSBITU306A BCK-Kuwait Portfollo Task 1 - Produce Spreadshee Compl ete all 23 instructions. berk for this assessment is 60% of the total of 50 marks. This means 30 marks are required tepass This assess ment counts s ment counts as 6% of your overall mark for this module. You have to prepare aTh raw data ve to prepare a spreadsheet summarizing the telecommunications cests of the for The raw data are, as follows:- February$729.68 Loca $ 896 $ 652.45 1,619.50 5,400.000 Phone- Long Distance Phone International Fax Cellular Internet Connection $1,444.10 $ 5,060 $ 950 $ 3,700 $4,400 6,850.00 $2,017.50- $4,985.00 $1,355.90 50 00 4,138.50 $4,550.00 4,510.00 Before you start, save the workbook (file) as: your first and last name-ID 1. (2 pts last name- ID number 2. [2 pts.] Enter the above data into the worksheet. Double check the data to ensure you made no mistakes. Change the currency from $to KWD 3. [1 pt.] Insert a field called "Totals showing the total costs for each month. 4. 12 pts) Calculate that total field for each month, showing how much the sixc expenses cost per 5. 13 pts.J Create a chart, which shows the costs by category for January ONLY. Think about which 6. [2 pts.J Each category i e six expenses cost per month e of chart presents such data the best, type of chart presents such data the best. 6. 12 pts) Each ateoryin the chart should be represented as a percentaze, not xWD amount. 7. (1pt) Ensure the chart has a title, legend, labels, etc. Move the chart under the table. in the chart should be represented as a percentage, not KWD amount. 8. 12 pts.] For each month, insert a row called "Budgeted Costs, under the Totals. The budgeted costs are, as follows:- Budgeted cost January: KWD 16,000 February: KWD 17,000 KWD 19,500 overi nder e March: "Budgeted Costs" shows the money, which the company prepares in advance for th monthly costs. It is a guess about how much the company will spend.) ld. Calculate the average co 9. 13 pts. Under the budgeted cost row, insert the "Av per month. 10. 3 ptsJ For each month, find the hishest cost (call it "Highest Cost") and put it under the avera cost. Amal Samarah Business Technology