Quiz › Formulas & Functions
Formulas & Functions Quiz
SUM, IF, VLOOKUP, text functions and the maths behind them. Choose a topic. Each topic has 5 questions.
The IF formula
If A1 = 45, what will this formula return? =IF(A1>=40,"Pass","Fail")
SUM and AVERAGE
A1 = 10, A2 = 20, A3 = 30. What will this formula return? =SUM(A1:A3)
Order of maths
What will this formula return? =10+5*2
COUNT, COUNTA, COUNTIF
A1 = 10, A2 has the word Hi, A3 is empty, A4 = 20. What will this formula return? =COUNT(A1:A4)
LEFT, RIGHT, MID
A1 has EXCEL2026. What will this formula return? =LEFT(A1,5)
VLOOKUP
A1:B3 has Apple 50, Mango 80, Kiwi 30. What will this formula return? =VLOOKUP("Mango",A1:B3,2,FALSE)
Rounding numbers
What will this formula return? =ROUND(2.567,1)
SUMIF and COUNTIF
A1:A4 has Pen, Book, Pen, Bag. B1:B4 has 10, 50, 20, 100. What will this formula return? =SUMIF(A1:A4,"Pen",B1:B4)
AND, OR and nested IF
A1 = 60 and B1 = 40. What will this formula return? =IF(AND(A1>=50,B1>=50),"Pass","Fail")
Joining text with &
A1 has Ravi and B1 has Kumar. What will this formula return? =A1&B1
MAX, MIN, LARGE, SMALL
A1:A5 has 40, 10, 90, 70, 30. What will this formula return? =MAX(A1:A5)
XLOOKUP, INDEX, MATCH
A1:A3 has Apple, Mango, Kiwi. B1:B3 has 50, 80, 30. What will this formula return? =XLOOKUP("Kiwi",A1:A3,B1:B3)
Want to learn first? Read the Formulas & Functions lessons →
← All quiz categories
