Nokia N800 - Does the alarm clock work when my Nokia phone is switched off?

Yes, your phone alarms on the specified time.

Note: Applies for most of Nokia Symbian and Series 40 phones.