Indexing enables the full text search of article texts. It's done in the background in Zotero when it's not doing anything else; queued means an article isn't yet indexed but will be; yes means it can be found using full-text search. It has nothing to do with your other questions (like sync, back-up, etc.)