Go to the Current Sales worksheet, which contains a table listing sales data for January, $2025.$ To make it easy

$\frac{0}{4}$

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.$

Create a formula using a function.

In the Current Sales worksheet, the formula in cell G$5$ should use the text "Mini $2"$ in the logicall argument.

Copy a formula into a range.

In the Current Sales worksheet, cell G$5$ contains an incorrect formula.