An inventory report provides data for three product categories (Electronics, Apparel, Home Goods) across four warehouses (W1, W2, W3, W4). Each row lists 'Category', 'Warehouse', 'Units in Stock', and 'Average Unit Cost'. To identify the warehouse holding the highest total value of 'Home Goods' inventory, which two columns would be most relevant for calculation, and what sorting/filtering steps would be appropriate?
✓ Correct Answer: Option B
To find the highest total value of 'Home Goods', first filter data to only 'Home Goods'. Then, for each warehouse, multiply 'Units in Stock' by 'Average Unit Cost' to find total value, and compare these values.