An autoexec.cfg file is a text file that you can edit with your settings and have those settings run every time Quake 4 starts without any interaction from you. You simply create a new text file in the Quake 4\q4base folder (the same location as the Quake4Config.cfg) and save it as autoexec.cfg.