In cell C$14,$ create a Single Input$-$Output Formula to calculate the Tax Amount, then copy the formula down through the range C$14$:C$18.$ In cell F$14,$ create a Dynamic Spilled Array Formula to calculate the Tax Amount, then spill the formula down through the range F$14$:F$18.$ In cell $114,$ create an Excel Table Formula to calculate the Tax Amount for the Excel Table field Tax Amount.

In the yellow cells below $($starting in the range B$22,$ write an answer and say which of the three formula method you like best.

Hint #$1$: Be sure to use the ROUND function to round to the penny for each formula.

Hint #$2$: Video #$3$ shows exactly how to create the three formulas : $)$

$\backslash$table$[[$Single Input$-$Output Formulas,Dynamic Spilled Array Formulas,Excel Table Formulas$],[$Tax Rate,$0\mathrm{.}1075,$Tax Rate,$0\mathrm{.}1075,$Tax Rat,$0\mathrm{.}1075],[$Sales$,$Tax Amount,Sales,Tax Amount,Sales,Tax Amoun $vv$