"apagado" means "turned off". That simple.

Greetings from Colombia

It depends on how you use it. As in "the switch is off" apagado or desconectado.

'is the fan (switched) off' in Spanish is 'esta apagado el ventilador?' (with an accent on the 'a' in 'esta')

Hablando de amigos que tengo un novio que se me ha encendido y apagado con los años

[The other day a policeman here in Italy wanted to arrest me because I was really very drunk out of my mind. Does anyone know if they can do that or if it's against the law here?] Voce estava muito bebado, nao e? O beber excessivamente e um crime.