Cell Clash: the live Excel quiz for teams and classes

How scoring works

• Up to 1,000 points a question: the faster you are right, the more you get.
• Streak bonus: +100 for every right answer in a row, up to +500.
• Every three in a row earns a power-up: Double points, Shield (a miss keeps your streak) or +5 seconds.
• Surprise rounds: Double Points, a Speed Round and a Sudden Death final.

10 sample Excel quiz questions (with answers)

These come from the game's question bank. Try them, then play live with your team.

1. Question 1 · Dates

   What does =DATE(A3,B3,C3) return?

   	A	B	C
   1	Year	Month	Day
   2	2026	3	15
   3	2026	11	30

   1. Nov 30, 2026
   2. Feb 1, 2027
   3. Mar 15, 2026
   4. Dec 1, 2026
   Show the answer

   Nov 30, 2026. Every answer here is calculated by the same formula engine the game uses.

2. Question 2 · Math

   What does =AVERAGE(B2:B5,C2:C4,50) return?

   	A	B	C
   1	Month	Rent	Utilities
   2	Jan	1200	145
   3	Feb	1200	162
   4	Mar	1250	128
   5	Apr	1250	n/a

   1. 2707
   2. 5385
   3. 673.125
   4. 435
   Show the answer

   673.125. Every answer here is calculated by the same formula engine the game uses.

3. Question 3 · Math

   What does =ROUND(B2*C2,2) return?

   	A	B	C
   1	Item	Net	Tax rate
   2	Office chair	149.99	0.0825

   1. 19
   2. 12.37
   3. 48000
   4. -3
   Show the answer

   12.37. Every answer here is calculated by the same formula engine the game uses.

4. Question 4 · Counting

   What does =COUNTA(D2:D5) return?

   	A	B	C	D
   1	Guest	RSVP	Meal	Plus one
   2	Hannah Lee	Yes	Fish	1
   3	Marcus Webb	No
   4	Sofia Ruiz	Yes	Veg	0
   5	Ian Park

   1. 2
   2. 3
   3. 5
   4. 4
   Show the answer

   2. Every answer here is calculated by the same formula engine the game uses.

5. Question 5 · Math

   What does =SUM(B2:D3) return?

   	A	B	C	D
   1	Week	Store A	Store B	Store C
   2	Week 1	4200	3850	5100
   3	Week 2	3975	4010	4890

   1. 26025
   2. 39385
   3. 4010
   4. 27805
   Show the answer

   26025. Every answer here is calculated by the same formula engine the game uses.

6. Question 6 · Math

   What does =ROUNDDOWN(B2,2) return?

   	A	B
   1	Item	Value
   2	Invoice total	1847.3249

   1. 6
   2. 1847.33
   3. 1900
   4. 1847.32
   Show the answer

   1847.32. Every answer here is calculated by the same formula engine the game uses.

7. Question 7 · Counting

   What does =COUNTIF($C$2:$C$9,">="&C3)+(COUNTIF($C$2:$C$9,C3)+1)/2 return?

   	A	B	C
   1	Rep	Region	Sales
   2	Priya	East	48200
   3	Marcus	West	51750
   4	Elena	East	39900
   5	Tom	East	51750
   6	Aisha	West	62300
   7	Ben	West	44100
   8	Grace	East	57800
   9	Luis	West	39900

   1. 4
   2. 5.5
   3. 3.5
   4. 2
   Show the answer

   5.5. Every answer here is calculated by the same formula engine the game uses.

8. Question 8 · Math

   What does =SUM(B2:B5)*$D$2 return?

   	A	B	C	D
   1	Rep	Sales		Flat rate
   2	Priya Nair	42500		0.05
   3	Marcus Webb	18200
   4	Elena Ruiz	67800
   5	Tom Becker	9750

   1. 6912.5
   2. 3346
   3. 8462.5
   4. 4000
   Show the answer

   6912.5. Every answer here is calculated by the same formula engine the game uses.

9. Question 9 · Logic

   What does =IF(OR(A5="",B5="",C5=""),"Incomplete","OK") return?

   	A	B	C
   1	Task	Owner	Done on
   2	Order labels	Priya	Oct 28, 2026
   3	Update price list	Marcus
   4	Call supplier		Oct 30, 2026
   5	Book courier		Oct 29, 2026

   1. No owner
   2. Incomplete
   3. Closed
   4. FALSE
   Show the answer

   Incomplete. Every answer here is calculated by the same formula engine the game uses.

10. Question 10 · Math

    What does =MOD(D2-C2,1)*24 return?

    	A	B	C	D
    1	Employee	Date	Start	End
    2	Rosa	Nov 2, 2026	22:00	6:30

    1. 6
    2. 7.75
    3. 8.5
    4. 50:15
    Show the answer

    8.5. Every answer here is calculated by the same formula engine the game uses.

FAQ