Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
% of row total. To turn a grid into row shares, divide each cell by its row’s total. Filling right must keep pointing at the total column, filling down must move to the next row’s total, so lock the column only: $E2. Each row of shares then adds up to 100%.
=B2/$F2 each product’s share of a store’s sales, store total in F
Daniel Ortiz suspects West depends far more on sales reps than the other regions. He wants each region’s 2025 revenue split into channel shares, like a pivot table’s “% of row total”.
In G2:I6, divide each channel’s revenue in B2:D6 by the total of the same row in column E. Write one formula in G2 that fills across and down. No rounding.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Region | Online | Sales Rep | Partner | Total | Online | Sales Rep | Partner | Check | |
| 2 | North | 38,987.39 | 30,912.15 | 14,537.47 | 84,437.01 | 0.0% | ||||
| 3 | South | 41,754.33 | 34,366.76 | 14,382.16 | 90,503.25 | 0.0% | ||||
| 4 | East | 26,025.52 | 22,271.99 | 12,466.35 | 60,763.86 | 0.0% | ||||
| 5 | West | 27,984.93 | 63,774.59 | 8,533.63 | 100,293.15 | 0.0% | ||||
| 6 | All regions | 134,752.17 | 151,325.49 | 49,919.61 | 335,997.27 | 0.0% | ||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe