Excel test
12-question test on essential Excel functions and habits: SUM, IF, COUNTIF, VLOOKUP, absolute and relative references. Suited to recruitment or internal assessment.
Recruitment Graded quiz · 12 questions · 25 min
Question preview
The questions are shown without the answers.
Cells A1, A2 and A3 contain 10, 20 and 30. What is the result of =SUM(A1:A3)?
Cell B2 contains 8. What is the result of =IF(B2>=10,"Pass","Fail")?
Range A1:A5 contains: yes, no, yes, yes, no. What is the result of =COUNTIF(A1:A5,"yes")?
What is the result of =AVERAGE(4,6,11)?
Which notation locks both the column and the row of cell A1 when copied?
Range A2:C4 contains: 101 / Pen / 2.50; 102 / Notebook / 4.00; 103 / Binder / 6.00 (one row per item). What is the result of =VLOOKUP(102,A2:C4,2,FALSE)?
A1 contains 3, A2 contains the text "abc", A3 contains 5 and A4 is empty. What is the result of =COUNT(A1:A4)?
COUNT only counts cells that contain numbers.
A1 contains "Mary" and B1 contains "Smith". What is the result of =A1&" "&B1?
What is the result of =ROUND(2.678,1)?
Cell B1 contains =A1*2. You copy it to B3. Which formula does B3 then contain?
A1 contains 7. What is the result of =IF(AND(A1>5,A1<10),"yes","no")?
A1:A4 contains X, Y, X, Y and B1:B4 contains 10, 20, 30, 40. What is the result of =SUMIF(A1:A4,"X",B1:B4)?
How it works
Create your free account, the template is added to your quizzes, then adapt the questions and send it to your participants.