Place it at the end of a scene, just after the defeat or departure is shown, so it acts as the closing beat. Follow it with a short laugh or a dramatic buzzer for contrast, and keep a cheer after that only if the edit needs a lift.