When the lights are on, there is a yellow light shining down from the roof near the garage door opener buttons. What is this for? Map light? Can I turn it off?
I don't think it's bright enough to be considered a map light. It's more of an effect light that just lights up the console area. It can't be turned off that I'm aware of.
No turning off but ... There is also a filter on it to keep it that dim, if not might be a little brighter. There is a DIY to change it out to make it more brighter. It is to keep "some" light on the cup holder area. Any post by TSM_Pikachu has a link in the signature section or you can search. If you normally want it little dimmer, you could put film like gift wrap and tape with tiny bit of electrical tape.
But at least if you check out that DIY, you can kind of see where that light was meant to focus, since it shows amplified in the pics there.
Its not really a map light but its just enough light to light up the console tray. I find it useless but its a interesting feature lol. My new accord has a blue LED light which does a better job at illuminating the console. You might want to check out that thread TSM_Pikachu posted on the LED upgrade.