Go to the Current Sales worksheet, which contains a table listing sales data for January, $2025.$To make it easy to refer to the data, the table has been renamed "Sales". Benicio wants to use the table data in formulas.In column G$,$ Benicio wants to indicate whether DIG Technology should send the customer a promotional offer. Customers are eligible for the offer if they purchased a Mini $2$ in the U$.$S$.$Provide the promotional offer information for Benicio as follows:a$.$ In cell G$5,$ start to enter a formula using the AND function and structured references.b$.$ The first condition tests whether the value in the Product column $([$@Product$])$ equals"Mini $2",$ the product eligible for the promotional offer.c$.$ The second condition tests whether the value in the Location column $([$@Location$])$ equals $"$U$.$S$.",$ the location eligible for the promotional offer.d$.$ If Excel does not fill the column, fill the range G$6$:G$40$ with the formula in cell G$5.$