LL I CC Income Deduction Instructions Follow the Instructions carefully accordingly PART 1 Gross Income Format the spreadsheet so it looks professional (expand cells, use boarders) -Where appropriate Use proper number formats (Currency and Percentage) where appropriate Deductions DeductionAmc Deduction Amount in Highlight headings (Use Cell Styles) and use boarders where appropriate - Centre the information Vacation 0.04 and use wrap text where appropriate. Expand the cell width so all the information fits in the cell CPP (Canadian Pension Plan) 0.0276 where appropriate 10 El (Employeement) 0.0103 Merage and Centre the Title ). Use any colour. 11 Federal Tax 0.159 12 Provincial Tax 0.0808 14 Total Deductions PART 2 16 Net Income INSERT $3000 for GROSS INCOME Calculate the Deduction Amount in ($) using (Absolute Cell Reference 20 21 PART 3 Calculate the TOTAL using the appropriate formula Calculate the NET INCOME using the appropriate formula PART A 28 create a Graph that focuses on the Deductions and the Total Amount. You can create either a pie or bar graph (of your choice). Title will be "Deductions" and include datalabels if possible N PART 4 Name the TAB - Income Deductions. Total