You have an Excel data table named Merch that contains data on all merchandise sales from a local concert venue. The table contains the following variables:

Price: the cost of each item

UnitsSold: the number of units sold of each item

Type: the category of item sold $($i$.$e$.$ records, shirts, hats, posters$)$

Where each row is an observation for a different item type.

You want to calculate total revenue for each item type by multiplying price by the number of units sold in each row. Which of the following formulas will calculate that using Table references outside the Excel Table so that the formula spills for all rows in the table?

Question $9$ options:

$=$Merch$[$@Price$]*$Merch$[$@UnitsSold$]$

$=[$@Price$]*[$@UnitsSold$]$

$=$Merch$[$Price$]*$Merch$[$UnitsSold$]$

$=[$@Price$*$@UnitsSold$]$