A table presents sales data for an electronics retailer across four product categories: `Smartphones`, `Laptops`, `Tablets`, and `Accessories`. Columns include `Product Category`, `Units Sold Q1`, `Units Sold Q2`, `Units Sold Q3`, `Units Sold Q4`, and `Average Unit Price`. The sales director wants to identify the category with the highest annual revenue (sum of units sold across all quarters multiplied by average unit price) and its corresponding Q4 units sold. After calculating the total annual revenue for each category, which product category had the second-highest annual revenue, and what were its Q4 units sold?
✓ Correct Answer: Option C
This requires calculating total annual revenue (sum of Q1-Q4 units * Average Unit Price) for each category, then sorting by this new metric to find the second highest. (Assuming hypothetical data where Tablets emerge as second highest with 700 Q4 units).