Steve Urkel, famously (4)
I believe the answer is:
nerd
(Other definitions for nerd that I've seen before include "Technical expert" , "Foolish or annoying person" , "Geek, anorak (sl.)" , "Socially inept but knowledgeable person" , "Intelligent but single-minded expert" .)