Your first 15 exercises are free, no sign-up. Pro unlocks every exercise, every reference solution, timed mode and the certificate.
All exercises
Basics 0/15 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 11 Running balance 12 Cheapest and most expensive plan 13 A rate that cannot divide by zero 14 Count the ticked checkboxes 15 Boxes to ship
Conditional counting and summing 0/20 16 Spend for one category 17 Late deliveries 18 Open high-priority tickets 19 Sales for one rep and month 20 Won deals above a minimum 21 Average reply time 22 Largest order in a region 23 Cheapest item in stock 24 Orders between two dates 25 Customer tiers with IFS 26 Region names with SWITCH 27 Contacts on one email domain 28 Active SKUs with a prefix 29 Free shipping rule 30 Weighted average score 31 Rank without RANK 32 Everything except one status 33 Revenue for one month 34 Average rating without the zeros 35 Contacts with no email
Lookups 0/16 36 Find the price 37 Stock on hand 38 Look left with XLOOKUP 39 A friendly "Not found" 40 INDEX and MATCH 41 Zero instead of #N/A 42 Shipping rate by weight band 43 Row and column lookup 44 Latest status in a log 45 Commission rate tier 46 Targets laid out in a row 47 Lookup by the start of a name 48 Next sailing on or after a date 49 Lookup on two keys 50 Place in the queue 51 Is the code on the list?
Arrays and FILTER 0/19 52 Sum a filtered list 53 Two conditions in FILTER 54 Distinct customers 55 Best seller with SORT 56 Top three deals with SORTN 57 Revenue with ARRAYFORMULA 58 Codes that are too long 59 QUERY for a total 60 Top region with QUERY 61 Count with QUERY 62 Either region with FILTER 63 Distinct products in a region 64 Revenue above a minimum quantity 65 Average since a date with QUERY 66 QUERY with a cell in the where clause 67 QUERY with contains 68 A sorted list from QUERY 69 Total overspend with ARRAYFORMULA 70 Distinct values in order
Text and dates 0/22 71 First name with SPLIT 72 Join the confirmed names 73 Address without gaps 74 Valid order IDs 75 Pull out the invoice number 76 Digits only 77 Month label with TEXT 78 Full years of service 79 Working days with holidays 80 Due at the end of next month 81 Tidy up pasted names 82 Items in a comma list 83 Domain of an email address 84 Renewal date with EDATE 85 Orders placed at the weekend 86 Amount inside a sentence 87 The part before the @ 88 Mask an account number 89 Ship-by date in working days 90 Day of the week as a word 91 Days until the deadline 92 Flag addresses that are not emails