$1.($max point deduction: $15)$ Calculate Income tax: For the first $$28,000,$ no taxes are withheld. For anything above $$28,000,$ the amount above $$28,000$ is taxed at $7\mathrm{.}25\%.$

a$.$ Create a new column for $$Income Tax$.$

b$.$ Compute income tax and place them in this column. HINT: You need an IF function here.

c$.$ Conditionally format the column such that if income tax is less than $$500,$ the cell is bold $($font$)$ and yellow colored $($text color only, NOT the fill color$)$; if income tax is between $$500$ and $$1500,$ make the cell bold $($font$)$ and fill it with light blue color.