MS Office Proficiency

Question Breakdown

• MS Word: Evaluates knowledge of document layout mechanics (section breaks vs. page breaks), advanced features (Mail Merge, Cross-referencing, automatic Table of Contents), and paragraph behavior (Widow/Orphan rules, Style templates).

• MS Excel: Tests proficiency with references (Absolute, Mixed, Relative), data handling error messages (#REF!, #VALUE!), conditional counting rules (COUNTIF/COUNTIFS), lookup dynamic setups (INDEX-MATCH, VLOOKUP), and PivotTable defaults.

• MS PowerPoint: Focuses on operational slide show setups (Slide Masters, Presenter View, Sections, custom navigation), animation vs. transition logic, presentation-mode shortkeys, and asset optimization (Compress Media).

• MS Outlook & General Office Core: Challenges mastery over automation workflows (Rules vs. Quick Steps), communication setups (Delegation, Caching, Thread Cleanup), collaboration tools (OneDrive Co-authoring, versioning controls), and global shortcuts (F12, double-click Format Painter).

Available Tests