If my computer is switched off, can I be infected by a virus?

No. But a virus could still be dormant inside the computer, waiting for certain 'trigger' conditions (such as a specific date) to activate and release its payload.