If the mobo is newer socket 775, it should be able to take a 2 Quad...
Not necessarily, a lot still only supported Celeron/Pentium/Duo.
@OP, there are a lot of socket 775 boards that support quad core processors, as well as lower end processors so could be upgraded. Is your question more "show me a motherboard that will support Core 2 Quad processors"?