Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Formulas. A formula starts with =. Instead of typing numbers, you point at cells by their address (column letter + row number), so the result updates when the data changes. + − * / work like on a calculator.
=A2*2 doubles whatever is in A2
Your manager wants West revenue for January and February together.
In D2, add West’s January revenue (B2) and February revenue (C2) with a formula.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Jan | Feb | Jan + Feb | ||||
| 2 | West | 9006.93 | 11781.48 | |||||
| 3 | ||||||||
| 4 | ||||||||
| 5 |
=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