Yes, it does. When creating a new task or editing an existing one, go to the Conditions tab and select Wake the computer to run this task.
Note that this will work only if the computer is sleeping. If you shut down the computer, Windows Task Scheduler can’t start the computer to run this task.