Does Task Scheduler work when computer is sleeping?

No, the task will not run if the PC is powered off. If the PC is simply in sleep or hibernation, you can use a wake timer to wake the computer to run the task. If your PC has the capability, you can set a timer in your CMOS settings to power on the PC right before the task is scheduled to run.