excel exam

Using MS$-$Excel, Design the following sheet

$\backslash$table$[[$Emp$\_$No$,$Emp$\_$Name,Gender,$\backslash$table$[[$Company$],[$Name$]],\backslash$table$[[$Basic$],[$Salary$]],$Bonus,Tax,$\backslash$table$[[$Net$],[$Salary$]]],[10,$Ali,M$,$CSS$,500,,,],[20,$Soso,F$,$CIS,$800,,,],[30,$Meme,$F,$CSS$,1200,,,],[40,$Jaber,M$,$CIS,$5400,,,],[50,$Nana,$F,$ATS,$1500,,,],[,,,,,,,]]$

Answer the following Questions:

$1-$ Change the name of your sheet to your name.

$2-$ Find the tax for each employee, the tax depends on the basic salary of the employee, if the basic salary $>2000$ Stax is $6\%$ of the basic salary, if the basic salary between $2000$ and $1000$ the tax is $4\%$ of the basic salary and if the basic salary $<mn\; id="EditorElement\_3280288">1</mn><mn\; id="EditorElement\_3280289">0</mn><mn\; id="EditorElement\_3280290">0</mn><mn\; id="EditorElement\_3280291">0</mn>$ the tax is $2\%$ of the basic salary.

$3-$ Bonus calculated as follows: if the gender is Male $(M)$ the bonus $=1005$ else the bonus $=505(1$pt$)$

$4-$ Find the net salary for each employee $($net salary $=$ basic salary $+$ Bonus $-$ Tax$).$

$5-$ Find the sum of Net salary for all female employees.

$(1$pt$)$

$6-$ Find the number of employees Works in CSS Company.

$(1$ pt$)$

$7-$ Highlight all basic salaries less than $1000$$ with blue color and greater than $1500$ with red color.$(1$ pt$)$

$8-$ If the basic salary is less than $300$ s an error message appear "error message must contains your name"

$9-$ Draw a chart between the Emp.$-$name and the net salary

$(1$ pt$)$

$(1$ pt$)$