On the original question of narration, as in nearly everything I think it depends. If the narrator of the story was a witness or participant who is now relating the story, then I think it's okay for that narrator to get excited and an exclamation point would be appropriate.
On the other hand, for an omniscient third party narrator, I don't think it would work.
On "interrobangs" and other "compound punctuation" marks, I reserve them for informal writing -- which could still include some stories. Especially stories with a young first person narrator.
|