Used to show extreme passion and expression towards anyone or anything. Usually follows an exciting event or victory. An experienced user of the phrase may say it at random out of pure addiction to the word.
(After winning in street fighter) "Hoooooooo!"
"Last night I fucked her in the ass doggystyle! Hooooooo!"