Generally yes. If you're revving the motor higher between gears then of course you're consuming more juice.
Also when in sport mode and downshifting and or braking the tranny will pick up a lower gear (earlier) and hold it longer than D mode as it anticipates that you need higher revs to pull you out of the turn/corner etc.
S mode driving really is a hoot