Is my UNO spoilt?

(deleted)

spoilt => broken?

But if it's a original Arduino then the program (that makes it act as a USB to Serial adapter) in the ATmega16U2 might be gone for some reason. You can try to reprogram the ATmega16U2 but you need a programmer or another Arduino to do so.