Using the Application: Files, Formats and the Program Interface
Knowing the environment
This domain tests whether you can operate the spreadsheet program itself rather than edit data. Expect questions on creating a blank workbook, opening an existing file, switching between open workbooks, saving, closing, and finding commands. Know where core commands live: the File area for New, Open, Save, Save As, Print and Options; the ribbon or menu bar for the tools used while editing.
Files and formats
Understand that Save writes changes to the current file, while Save As lets you choose a new name, location or format and becomes the active file afterwards. A default workbook is normally .xlsx; .csv stores plain text values only, with no formulas, formatting, charts or extra sheets; .pdf is for fixed distribution. Templates start a new file preloaded with structure.
Traps in questions
- Confusing Save with Save As when a copy in a new location is required.
- Assuming a CSV keeps formulas: it keeps only calculated results, and typically only the active sheet.
- Forgetting that closing a workbook with unsaved changes prompts a save, while closing the application may prompt once per workbook.
- Mixing up zoom (view only, no effect on data or print) with a real font size change.
Rule of thumb
Before any risky step (converting to CSV, sending a file, closing), use Save As to create a versioned copy such as Budget_v2.xlsx, then edit the copy. This one habit protects the original and satisfies most backup-style questions.