0 of 50 solved
5 of 50 exercises are free. Pro unlocks the rest.
All exercises Basics 1 Total ad spend 2 Average order value 3 Round the unit price 4 One rate for every row 5 Over budget? 6 Share of total sales 7 Month-over-month growth 8 Price after discount 9 Commission over a threshold 10 Count the survey responses Conditional counting and summing 11 Open high-priority tickets 12 Sales for one rep and month 13 Won deals above a minimum 14 Average reply time 15 Largest order in a region 16 Cheapest item in stock 17 Orders between two dates 18 Customer tiers with IFS 19 Region names with SWITCH 20 Contacts on one email domain Lookups 21 Find the price 22 Stock on hand 23 Look left with XLOOKUP 24 A friendly "Not found" 25 INDEX and MATCH 26 Zero instead of #N/A 27 Shipping rate by weight band 28 Row and column lookup 29 Latest status in a log 30 Commission rate tier Arrays and FILTER 31 Sum a filtered list 32 Two conditions in FILTER 33 Distinct customers 34 Best seller with SORT 35 Top three deals with SORTN 36 Revenue with ARRAYFORMULA 37 Codes that are too long 38 QUERY for a total 39 Top region with QUERY 40 Count with QUERY Text and dates 41 First name with SPLIT 42 Join the confirmed names 43 Address without gaps 44 Valid order IDs 45 Pull out the invoice number 46 Digits only 47 Month label with TEXT 48 Full years of service 49 Working days with holidays 50 Due at the end of next month Progress is saved in this browser. Create a free account to keep it everywhere.
Basics 1 / 50
Total ad spend Six marketing channels and their spend for the month are listed. Click B8, type a formula in the formula bar that adds up all six, press Enter, then choose Check answer.
fx
A B C D 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 to fill. Click one, type a formula in the bar above and press Enter.
Check answer Hint Solution (after 2 tries) Timed mode: off
Sheetsdrill