just the formulas please!

cell range ex A$2$:A$113$

$25.$ Employees with Years of Service longer than ten will receive Long Service

Awards. Use the Logical function to determine who qualifies for the

awards in the Long Service Awards column. If so$,$ show Yes. Otherwise,

indicate No$.(3$ marks$)$

Refer to Tutorial $3$ Q$1$

$26.$ Employees' Raise percentage determines by their Pay Grade. See the

Question $26$ table in the $"$Q$25-30"$ Worksheet. Use the Logical function to

determine the Employee's Raise percentage in the Employees' Raise

percentage column. $(4$ marks$)$

Refer to Tutorial $3$ Q$5$

Hint: This question requires three If functions to solve it$.$

$1)$ The first If function checks whether the employee is a Pay Grade A$.$ If

so$,$ it returns $1\mathrm{.}25\%.$ If not, go to the second if function.

$2)$ The second If function checks whether the employee is a Pay Grade B$.$

If so$,$ it returns $1\mathrm{.}5\%.$ If not, go to the third if function

$3)$ The third If function checks whether the employee is a Pay Grade C$.$ If

so$,$ it returns $2\mathrm{.}5\%.$ If not, it will return $0\mathrm{.}5\%$ because it is not A$,$ B$,$ or C$.$

$4)$ Remember to use the Absolute Cell Reference for the Range

$27.$ Employees will receive a milestone bonus for $10,15,20,$ or $25$ Years of

Service. In Milestone Bonus column uses the Logical function to calculate

Milestone Bonus $($Milestone Bonus $=$ Annual Salary $*$ Milestone Bonus

Percentage$)$ for the eligible employees. For ineligible employees, the

milestone bonus will equal $$0.$ Milestone Bonus Percentage can be found

in the $"$Q$25-30"$ Worksheet.

Change the column category to Currency and set decimal to $2.(5$ marks$)$

Hint: This question requires using the If with Or function to solve it$.$

Start with the If function. In the Logical$\_$Test field, use Or function to create

the logic$\_$test, similar to Tutorial $3-$ Q$2.$ In the Value$\_$if$\_$true field, return

the calculation value. In the Value$\_$if$\_$false field, return $$0.$

$=$if$($logical$\_$test,value$\_$if$\_$true,value$\_$if$\_$false$)$

$$ logical$\_$test: Or $($D$2=10,$ D$2=15,$ D$2=20,$ D$2=25)$

$$ value$\_$if$\_$true: Annual Salary $*$ Milestone Bonus Percentage

$$ value$\_$if$\_$false: $0$

Remember to use the Absolute Cell Reference for the Milestone Stone

Percentage

$28.$ The Board of Directors wants to keep the total Milestone Bonus equal to

$$25,000.$ Use the Solver function to find the Milestone Bonus percentage

to meet the $$25,000$ target. $(3$ marks$)$

Refer to Tutorial $3$ Q$8$

Hint: First, determine the Total Milestone Bonus. Then use the Solver

function to find the Milestone Bonus percentage that will meet the $$25,000$

target.

To use the Solver function to solve the Milestone Bonus Percentage, you

must use the Absolute Cell Reference for the Milestone Stone Percentage in

Question $27$

$29.$ Use the Logical function to calculate Tax Deduction for each employee in

the Tax Deduction column.

Tax Deduction $=$ Annual Salary $$ Tax Rate.

The Annual Salary determines the Tax Rate. See Question $29$ table in $"$

Q$25-30"$ Worksheet. $(5$ marks$)$

Annual Salary Tax Rates

Less than or equal to $$47,63015\mathrm{.}00\%$

Greater than $$47,630$ and less than or equal to $$95,25917\mathrm{.}75\%$

Greater than $$95,259$ and less than or equal to $$147,67720\mathrm{.}50\%$

Greater than $147,67722\mathrm{.}62\%$

Refer to Tutorial $3$ Q$4$

$30.$ Employees who belong to Pay Grade B$,$ C$,$ or D$,$ have over $5$ Years of

Service, and are in the Finance or Marketing department, will receive a

Bonus. Using the Logical functions determines the Bonus $($Bonus $=$ Annual

Salary $*$ Bonus Percentage$).$

Please find the Bonus Percentage in the $"$Q$25-30"$ Worksheet. If the

employee doesn't match the criteria, the Bonus will equal $$0.$

Insert a new column on the left of the Tax Deduction; name the column

with the heading "Bonus." Change the column category to Currency and

set decimal to $2.(5$ marks$)$

Refer Tutorial $3$ Q$7$

Hint: First, determine all the criteria. Then use if$,$ and, or functions to

combine all the requirements.

Here are the requirements:

$1)$ Paygarde is B$,$ C$,$ or D

$2)$ Years of Service $>5$

$3)$ Finance or Marketing department