a$)$ Usean IF statement to design ate thesurcharge $($in column C$)$ for ach chargein column $8.$

The surcharge for each record is determined using the following logic:

b$)$ Usea NESTED IF stat ement whth embed ded AND OR functions to cakulate the Olscount Rate $($Column D$)$ for each corresponding Sales Amount $($column B$)$ and Region $($column C$).$

The Discount Rate is calculated using the following logic:

c$)$ Use the IFS statement to determine grades according to thestandard $10-$point scale

For eample, if a student's score $x89\mathrm{.}5$ they recele an $\text{'}A\text{'}$ in the cass.

Thecriteria ares in columns GJ contain theg adelower bound values and letter grades to beused as ret urn values

$\backslash$table$[[$Student$,$Score,Class Grade$],[$Karter$,92\mathrm{.}3,],[$Pevton$,75\mathrm{.}4,],[$Parker$,68\mathrm{.}8,],[$Samue$,96\mathrm{.}4,],[$Linsay$,47\mathrm{.}3,],[$Ryan$,88\mathrm{.}7,],[$Trave$,72\mathrm{.}1,]]$

Use the CONCATfunction and nested CHOCSE functions to createaOutput statement in cell CS$3$ that displaps an imal name$/\text{'}$sound information.

Thest atement is based on the user's choice in cell C$50$ and ref erences the animal name$/$sound pair table shown below.

Indec

Samplestring

My favorite animal is a dog; this animal says woof.

$($based on cell $C50=1)$

Your String:

$\backslash$table$[[$Animal name$/$sound pair table$],[$dog$,$woof$],[$cat$,$Eat$-$emup$],[$cow$,$mooo$],[$dudk$,$quack$],[$owl$,$who$-$who$]]$

ENSURE cell C$50$ displays the value $\text{'}1\text{'}$ when turning in the assignment for grading.