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 total in a summary table. Once a summary column exists, a share column is one more formula: the row’s value divided by the table total. The row’s value moves as you fill down, the total must not, so lock it with $. The shares should add up to 100%.
=C2/$C$8 each team’s share of all hours
For the annual review, the category managers want 2025 revenue by product category and each category’s share of the total, the way a pivot table’s “% of grand total” shows it.
In H2:H5, total the product revenue in C2:C25 for the category in G2:G5. In I2:I5, divide each category’s total by the grand total in H6. Fill each column down from row 2. No rounding.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Product | Category | Revenue 2025 | Category | Revenue | Share | |||
| 2 | Copy Paper A4 (500) | Paper & Print | 2,791.60 | Paper & Print | |||||
| 3 | Recycled Paper A4 (500) | Paper & Print | 3,454.33 | Coffee & Kitchen | |||||
| 4 | Toner Cartridge Black | Paper & Print | 31,149.05 | Cleaning | |||||
| 5 | Toner Cartridge Color | Paper & Print | 52,747.80 | Desk Supplies | |||||
| 6 | Label Roll (1000) | Paper & Print | 7,097.35 | Total | 0.00 | 0.0% | |||
| 7 | Envelope Box (250) | Paper & Print | 6,703.20 | ||||||
| 8 | Espresso Beans 1kg | Coffee & Kitchen | 31,681.20 | ||||||
| 9 | Filter Coffee 1kg | Coffee & Kitchen | 9,467.74 | ||||||
| 10 | Paper Cups (1000) | Coffee & Kitchen | 39,699.00 | ||||||
| 11 | Tea Assortment (200) | Coffee & Kitchen | 9,608.74 | ||||||
| 12 | Oat Milk 12-pack | Coffee & Kitchen | 18,523.38 | ||||||
| 13 | Sugar Sticks (1000) | Coffee & Kitchen | 6,827.70 | ||||||
| 14 | All-Purpose Cleaner 5L | Cleaning | 8,064.70 | ||||||
| 15 | Hand Soap Refill 5L | Cleaning | 11,970.93 | ||||||
| 16 | Paper Towels (24) | Cleaning | 14,720.00 | ||||||
| 17 | Trash Bags (200) | Cleaning | 9,886.50 | ||||||
| 18 | Disinfectant Wipes (12) | Cleaning | 7,663.95 | ||||||
| 19 | Microfiber Cloths (50) | Cleaning | 13,516.04 | ||||||
| 20 | Ballpoint Pens (50) | Desk Supplies | 4,510.64 | ||||||
| 21 | Sticky Notes (24) | Desk Supplies | 7,342.80 | ||||||
| 22 | Stapler Heavy Duty | Desk Supplies | 10,747.00 | ||||||
| 23 | Whiteboard Markers (12) | Desk Supplies | 8,565.82 | ||||||
| 24 | Desk Organizer | Desk Supplies | 10,554.50 | ||||||
| 25 | Notebook A5 (10) | Desk Supplies | 8,703.30 | ||||||
| 26 | |||||||||
| 27 | |||||||||
| 28 |
=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