Resonance in black hole ringdown: Benchmarking quasinormal mode excitation and extraction