AnalystReps

Excel & Sheets practice: Multi-Range Matrix Math

Chapter 8 · 3 questions · included in full access

  1. Question 1 · hard

    Accessories revenue from scratch

    Pretend the Revenue column does not exist. In K2, compute total revenue for Accessories directly from Units × Price, in one formula with SUMPRODUCT.

    Solve it in your browser

  2. Question 2 · hard

    Orders placed in February

    Count the orders placed in February using SUMPRODUCT and MONTH — no date window this time. Answer in K2.

    Solve it in your browser

  3. Question 3 · easy

    Totals under a filter

    You filter the Sales table to show only North orders. Which formula below the table shows the total revenue of just the visible rows?

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing