mediumBoost · aggregationBasic
Build a two-way cross-tab of Boost wallet top-ups
Column A holds a Boost top-up's channel, column B its top-up method, column C the amount. D2:D3 already lists the distinct channels ("App", "Kiosk"), E1:F1 the distinct methods ("Card", "eWallet"). Write formulas in E2:F3 that fill in the cross-tab: total amount for each channel-and-method combination.
Starting grid
A1
Scroll to see all 6 columns →
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Channel | Method | Amount | Card | eWallet | |
| 2 | App | Card | 50 | App | ||
| 3 | App | eWallet | 30 | Kiosk | ||
| 4 | Kiosk | Card | 100 | |||
| 5 | App | Card | 20 | |||
| 6 | Kiosk | eWallet | 15 |
Basic
The expected output and walkthrough for this question unlock with a Basic plan.
Basic
The reference formulas and walkthrough for this question unlock with a Basic plan.
See Basic plansRM 25/mo · cancel anytime
Basic
This is a Basic question
Premium practice questions unlock with a Basic plan. The full solution, expected output, and grading are available to Basic members.
RM 25/mo · cancel anytime