a: Click the Fleet sheet tab and select cell G$5.$ Figure $2-106$ Mixed references in the new formula Rental boats with a stove in the galley must seat $8$ or more people.

b$.$ Create an IF function in which the logical$\_$test argument determines if there are $8$ or more seats.

c$.$ Use Yes for the value$\_$if$\_$true argument. Use No for the value$\_$if$\_$false argument. $($If you type the formula, enclose the text arguments within quotation marks.$)$

d$.$ Copy the formula to cells G$6$:G$19$ without formatting and then center the data in column G$.$ Insert the TODAY function in cell B$21.$ Format the date to show the month spelled out, the date, and four digits for the year $($January $1,2020).$