Create and copy an IF function.

a$.$ Select cell H$6$ and start an IF

b$.$ Type a logical$\_$argument to determine if cell $G6$ is greater than or equal to $)($ cell $F6.$

c$.$ Type Yes as the Value$\_$if$\_$true argument and No as the Value$\_$if false argument.

d$.$ Copy the formula in cell $H6$ to cells $H7$:$H20$ without formatting to maintain the fill color.

e$.$ Center align cells $H6$:$H20.$

f$.$ Press Ctri$+$Home.

$$ Insert a new sheet at the end of the tab names and paste the range names starting in cell A$1.$ AutoFit columns $A$:$B$ and name the worksheet as Range Names.

$$ Save and close the workbook $($Figure $2-102).$