$\backslash$table$[[,$hat$(n),$B$,$c$,,$E$],[7,$Kllometer travelled $=,7,,,],[3,$Taxi Service,$\backslash$table$[[$Cost$/$kilom$],[$eter $($K$)]],\backslash$table$[[$Transport$],[$Cost to Selling$],[$Place $($K$)]],\backslash$table$[[$Total Cost$],[($K$)]],$Recommendation$],[4,$Comfort,$12,5,89,$Do not Hire$],[5,$Malolo,$6,10,52,$Hire$],[6,$City Loop,$9,4.,67,$Hire$],[7,$Skyline,$10,3,73,$Hire$],[8,$Bestie,$13,4,95,$Do not Hire$],[9,$Sea Ruts,$7,9,58,$Hire$],[10,$Jets,$8,8,64,$Hire$],[11,$Set Mangi,$6,11,53,$Hire$],[12,,,,,],[13-2,$Total,$71,54,561,]]$

Use the spread sheet above to answer the following questions.

i$.$ Using the equation $C=mx+c,$ you are to calculate in column $C,$ the Total Cost of hiring the various taxi services, where $\text{'}m\text{'},$ is the cost per kilometre in column $B,\text{'}x\text{'}$ is the kilometre travelled entered in cell B$1$ and $\text{'}c\text{'}$ is the transport cost to selling place in column C$.\text{'}$ Write the formula used to calculate the total cost for hiring the Comfort taxi in cell D$4.$

$(3$ marks$)$

ii$.$ What would be the resulting formula in cell D$11,$ if the formula in i$)$ above is copied down?

$(2$ marks$)$

iii. Row $13$ is for the total for each column, What formula would have yielded the value in cell B$13?$

$(1$ mark$)$

iv$.$ What would be the resulting formula if you copy the formula in cell B$13$ above to cell D$13?$

$(1$ mark$)$

v$.$ Write an IF$()$ statement to display the result $\text{'}$Do not Hire', in cell E$4,$ if the total cost for Comfort in cell D$4$ is more than K$80.$ Otherwise it should display 'Hire' as shown in column E$.$

$(3$ marks$)$

vi$.$ If the formula in cell E$4$ above is copied to cell E$11,$ what is the resulting formula?

$(2$ marks$)$