Home › Learn Excel › Excel tests › Basic Excel test
Twelve practical tasks at the level most office jobs test first: sums, averages, a simple IF, percentages and sorting. No tips, a score at the end, and a certificate when you pass.
SUM adds up a whole range of cells. B2:B6 means B2 up to and including B6. Add up the monthly costs in B7AVERAGE adds up the numbers in a range and divides by how many there are. Work out the average customer rating in B7COUNTIF counts the cells that meet a condition. It has two parts: where to look and what to count. Count how many invoices are "Paid", in D2IF checks a condition. It returns one value when the condition is true and another when it's false. Show "Pass" in C2 if the score is 60 or more, otherwise "Fail"$E$2), so the formula still points to E2 when you copy it down. Work out Emma's commission in C2, with the rate in E2 lockedROUND rounds a number to the number of decimals you choose. It changes the value itself, not just how it looks. Round the price in B2 to two decimals, in C2MAX returns the highest number in a range, and MIN the lowest. Find the highest temperature of the week, in B9The basic Excel test checks the skills every spreadsheet user needs. You work in a real Excel window: click a cell, type the formula and press Enter. A few tasks are short questions or ask you to use a menu, the way employer tests do.
Take it if you're applying for an office, admin, customer service or retail role, or if you want proof that you know the basics. When you score 70% or more, you pass and can claim a certificate with your name and score to share on LinkedIn.
"Show Pass in C2 if the score in B2 is 60 or more, otherwise Fail." The answer: =IF(B2>=60,"Pass","Fail"). Simple tasks like this make up most of a basic Excel test. What testers look for is a correct formula with cell references, not a typed number.
Scored 90% or more? Move on to the intermediate Excel test. Missed a few tasks? The Excel lessons teach the same formulas with a tip at every step. Not sure the basic test is right for you? Find out with the Excel level test.
A short test that checks whether you can do everyday spreadsheet work: add up and average numbers, count with a condition, use IF, work out percentages and sort and filter a table.
70% or more, so at least 9 of the 12 tasks. With 90% you get a silver medal, and with 100% a gold one.
About 8 minutes. There's no time limit.
Yes, as often as you like. Your best score counts, and it's the one on your certificate.