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 Add it up 2 Class average 3 Best and worst month 4 Tax on every line 5 Percent change 6 Count the numbers 7 Count the answers 8 Round to cents 9 Profit margin 10 Running total 11 Typical house price 12 Second biggest deal 13 Share of total 14 Order in full cases 15 Missing timesheets
Logic and counting 0/24 16 Pass or fail 17 Letter grades 18 Bonus for the north 19 Count the shipped orders 20 Sales for one region 21 Two conditions at once 22 Flag for review 23 Count with two conditions 24 Average for one region 25 Scores above a bar 26 Best sale in a region 27 Shipping tiers 28 No more #DIV/0! 29 Rank with ties 30 Count with a wildcard 31 Discount rules 32 Average with two conditions 33 Sales between two dates 34 Plan codes to prices 35 Revenue for one region, no helper column 36 How many different customers 37 One region or the other 38 Everything except one status 39 Name a step with LET
Lookups 0/16 40 Find the price 41 Look left with INDEX and MATCH 42 When the code does not exist 43 Tax bracket lookup 44 Finishing position 45 Price grid 46 Return from the left 47 Price list into an order 48 A lookup inside IFERROR 49 Who sold the most 50 A column number that moves 51 Commission tiers with XLOOKUP 52 The most recent price 53 INDEX and MATCH on two conditions 54 Everyone in one department 55 Third place
Text and dates 0/21 56 Build an email address 57 Pull out the domain 58 Payment due dates 59 Clean up names 60 Join the tags 61 Digits only 62 Days between dates 63 Year and month 64 Contract end date 65 Pay by month end 66 Split last name, first name 67 Calendar quarter 68 Month labels with TEXT 69 IDs with leading zeros 70 Mask an account number 71 File extension 72 Completed years of service 73 Working days on a task 74 Ship-by dates 75 Weekend or weekday 76 Days in the month
Finance 0/17 77 Loan installment 78 Is the project worth it? 79 Growth over time 80 Portfolio return 81 Internal rate of return 82 Value of an annuity 83 Total interest on a loan 84 Compound annual growth 85 Break-even units 86 Straight-line depreciation 87 Monthly deposit for a goal 88 Effective annual rate 89 Months to clear a balance 90 The rate behind a financing offer 91 Interest and principal in one payment 92 NPV on irregular dates 93 Average price paid
Work mode 0/11 94 Clean the customer names 95 Numbers stored as text 96 Sales by region with messy labels 97 Flag duplicate orders 98 Days late from text dates 99 Lookups that fail on stray spaces 100 Lookup on two keys 101 Share of tasks done 102 Invoice aging buckets 103 Overtime on a timesheet 104 Sales per month from a date column
Find the error 0/14 105 The budget that looks fine 106 A rate typed into a formula 107 Commission copied down 108 Growth that does not add up 109 The wrong price column 110 An average with the wrong count 111 A region total that misses a row 112 A loan payment that is far too high 113 Variance with the wrong sign 114 A count that ignores its threshold 115 The lookup without FALSE 116 An NPV discounted one year too many 117 Grades tested in the wrong order 118 A growth rate over the wrong number of years