Grader $-$ Instructions

Wk $02$ In$-$Class $1$

Project Description:

Use the IF function to change the tax rate based on the grand total of the earnings

Steps to Perform:

Step

Instructions

$1$ Open the file Wk $02$ If Function Source file.

$2$ In cell F$3$ insert a function that will sum the values of B$3$:E$3.$ Repeat for rows $4$ and $5$

$3$ In cell F$7$ insert a function that will sum the values of F$3$:F$5$

$4$

In cell J$2$ create a function that will display a tax rate of $10\%$ if the value in cell $F7$ is greater than or equal to $300,$ and display a tax rate of $5\%$ if the value in F$7$ is less than $300$

$5$

In cell G$3$ insert a formula that will calculate the taxes paid based on the value in F$3$ and the tax rate. Repeat for cell G$4$ and G$5.$ Use an absolute reference to refer to the tax rate in J$2.$

$6$ In cell F$8$ sum the values from G$3$:G$5$

$7$ Save and close the Wk $02$ If Function Source file

$8$ Submit for grading