Definition of Advanced Excel user varies according to expectation. Someone thinks advanced users should know all the VBA, Pivot Tables and be able to write super long formula. Someone considers oneself “Advanced” for knowing the basic of VLOOKUP. On the contrary, your boss may consider Power Pivot or Power Query as “Basic” Excel skill although h/she may have no idea what it is… 😦
Is this something bothering you?
No worries. I am going to share with you probably the world shortest and the best Excel Proficiency Test that gives good indication of someone’s Excel skill in 3 seconds.
Want the test? Here we go (Just for Fun):
Tell me what the following numbers mean to you?
(To be answered within 3 seconds)
| 16,384 |
| 1,048,576 |
| 17,179,869,184 |
Bonus Question: What were these numbers previously?
(To be answered within 3 seconds)
If you can tell all the answers instantly, congratulations! You must be an Excel nerd. 🙂
wmfexcel 
max columns, max row number in excel, and the third one i don’t recognize… Cells?
LikeLike
Yea you are correct!
LikeLike