Microsoft Office Questions with Solutions

Microsoft Office questions test practical knowledge of the most widely used office applications: MS Word for documents, MS Excel for spreadsheets, MS PowerPoint for presentations, and MS Access and Outlook at a basic level. Common topics include file extensions (.docx, .xlsx, .pptx), menus and ribbon tabs, formatting features, keyboard shortcuts, and mail merge in Word. For Excel, questions cover cell references (relative, absolute and mixed, such as $A$1), common functions (SUM, AVERAGE, COUNT, IF, VLOOKUP), charts and sorting. For PowerPoint, they cover slide views, transitions and animations. Keyboard shortcuts such as Ctrl + Z (undo), Ctrl + Y (redo), F5 (start slideshow) and F7 (spell check) are among the most frequently asked questions, so a shortcut revision sheet is very useful. Practise the Microsoft Office questions below. Each answer includes an explanation.