Add another data series to the chart to represent the number of items ordered. Use the value of cell B1 as the series name and cells as the series values Do not rebuild the chart from scratch

A consulting manager wants to calculate her employees take home salaries to ensure they remain competitive. 1. Use a LOOKUP to populate each employees tax rate in Column F 2. Calculate each employees tax amount in Column G (tax rate " salary) 3. Greate an input table to show the following medical premiums paid by the employee: $1,800 for Management $1,200 for Non-Management 4. Use a LOOKUP function to populate the Medical Premium Paid in Column H 9. 5. Calculate the Take Home Salary in Column I (salary - tax amount-medical premium paid) 10 6. Calculate the Take Home Salacy as a \% of Total Salary in Column I 11. 12. Populate this table using formulas only. 13 Format your final tables to make them easy to interpret. 14 Print to PDF 15 16. UPLOAD 17. 1. Your formatted table printed to PDE 18. 2 Your Excel file