0 of 68 solved

Your first 15 tasks are free, no sign-up. Pro unlocks every task, every reference solution, timed mode and the certificate.

Today's leaderboard

No points yet today. Solve a task to be first.

10 points per task. You appear here once you log in.

Take the 15-minute test

Ten tasks from every level, one clock, a score you can share. One attempt a day free; Pro retakes any time.

All exercises

Basics 0/11

Conditional counting and summing 0/14

Lookups 0/13

Arrays and FILTER 0/14

Text and dates 0/16

Progress is saved in this browser. Create a free account to keep it everywhere.

Basics1 / 68

Total ad spend

Six marketing channels and their spend for the month are listed. Click B8, type a formula that adds up all six, press Enter, then press Enter again (or choose Check answer).

	A	B
1	Channel	Spend
2	Search	$1,240.00
3	Social	$860.50
4	Video	$415.00
5	Email	$120.00
6	Display	$302.25
7	Podcast	$95.00
8	Total

Highlighted cells are yours. The sheet works like Excel: type in a cell or the formula bar, Enter, Tab, Shift+arrows, Ctrl+C and Ctrl+V, Ctrl+D, the fill handle, F2, F4, Ctrl+Z. Press Enter on a cell when you are done to check.