Home › Excel tests › Excel formulas test
Excel formulas test
Which Excel formulas do you really know? This formulas test checks the ten functions that come up most in Excel tests and job interviews, one at a time. Type each formula yourself in the Excel window. Stuck? Press Hint, or open the explanation of that function.
In this guide
How the formulas test works
Each block below is one task about one function, with no step-by-step tips. Write the whole formula, press Enter and see if it's right. Do them in order, from easy to harder, or jump to the function you want to check. A formula that gives the right result in another way counts too.
SUM test
- Add up the costs in B5
IF test
- Show "Yes" in C2 if the age is 18 or older, otherwise "No"
COUNTIF test
- Count the tasks that are "Done", in D2
SUMIF test
- Add up the hours of Ana, in E2
VLOOKUP test
- Find the stock of the Lamp with VLOOKUP, in F2
XLOOKUP test
- Find the e-mail of Mo with XLOOKUP, in F2
INDEX MATCH test
- Return the score of Yara with INDEX and MATCH, in F2
IFERROR test
- Look up the price of a Kiwi, and show "Not found" if it's missing, in E2
TRIM test
- Clean up the extra spaces in A2, in B2
NETWORKDAYS test
- Count the working days between the two dates, in C2
What to do next
- All ten right? Take a full intermediate Excel test and earn a certificate.
- Missed a few? Open the explanation of that function, then try the task again.
- Want to practise them all in order? The Excel lessons build these formulas up step by step.
Frequently asked questions
Which Excel formulas should I know for a test?
SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP or XLOOKUP and IFERROR cover most basic and intermediate tests. For advanced tests add INDEX MATCH, SUMIFS, COUNTIFS, SUMPRODUCT and dynamic arrays like FILTER.
Is VLOOKUP or XLOOKUP better to use in a test?
Both are accepted. XLOOKUP is easier and more flexible, but VLOOKUP is still asked a lot, so know both.
Does a different formula with the same result count?
Yes. If your formula gives the right result in the right cell, it counts. That's also how most real Excel tests work.
Do I need Excel installed?
No. Every task runs in a small Excel window in your browser.