MS Office Suite: Word, Excel, PowerPoint and Access
MS Office questions test whether a candidate knows which application is used for which task and whether the basic parts, file extensions and shortcuts of each application are clear. The questions are direct and factual, so a short, well-organised revision can secure almost full marks.
This deep-study note covers the basic terms, the main applications, the important features and shortcuts, the question patterns, a solving method, the traps examiners set and a preparation plan. After reading it, a candidate should be able to identify the correct application, extension or shortcut without hesitation.
Basic Terms
- MS Office: a suite of application software from Microsoft for documents, spreadsheets, presentations, databases and e-mail.
- MS Word: a word processor used to create, edit, format and print text documents such as letters and reports.
- MS Excel: a spreadsheet program used for calculations, tables, charts and data analysis.
- MS PowerPoint: a presentation program used to make slideshows with text, images, charts and animation.
- MS Access: a database management system used to store and query data in tables.
- MS Outlook: an e-mail and personal information manager.
- Ribbon: the strip of tabs and commands at the top of a Word, Excel or PowerPoint window.
- Workbook: an Excel file that contains one or more worksheets.
- Worksheet: a single grid of rows and columns in Excel.
- Cell: the box formed by a row and a column, identified by a reference such as A1.
- Formula: an expression that begins with an equals sign and calculates a value in Excel.
- Function: a ready-made formula such as SUM, AVERAGE, IF or COUNT.
- Slide: a single page of a PowerPoint presentation.
- Template: a pre-designed file that gives a ready layout for a document, sheet or slide.
Core Concepts and Rules
- Word is for text, Excel is for numbers, PowerPoint is for slides and Access is for databases.
- The default extensions are .docx for Word, .xlsx for Excel, .pptx for PowerPoint and .accdb for Access.
- An Excel formula always begins with the equals sign, and every function is written after it.
- A workbook contains worksheets, and each worksheet is made of cells arranged in rows and columns.
- A cell reference is the column letter followed by the row number, such as B5.
- Word-processing features include spell check, find and replace, headers and footers, and mail merge.
- Excel functions such as SUM, AVERAGE, MIN, MAX, COUNT and IF are the most frequently asked.
- PowerPoint has views for normal editing, slide sorter, notes and the slide show.
- Common shortcuts are Ctrl+C to copy, Ctrl+V to paste, Ctrl+X to cut, Ctrl+Z to undo, Ctrl+S to save, Ctrl+B for bold, Ctrl+I for italics and Ctrl+U for underline.
- In Excel, Ctrl+Arrow moves to the edge of data and F2 edits the active cell.
The Four Main Applications
MS Word is a word processor, so anything that is mainly text, such as a letter, a notice, a report or a resume, is made in Word. MS Excel is a spreadsheet, so anything that involves numbers, tables, totals, charts or analysis is made in Excel. MS PowerPoint is a presentation program, so anything meant to be shown on a screen as slides is made in PowerPoint. MS Access is a database program, so anything that needs to store many records and run queries is made in Access. MS Outlook handles e-mail, calendar and contacts. Remembering the one-line purpose of each application answers most identification questions.
Important Features and Shortcuts
Word offers spell check, grammar check, find and replace, headers and footers, page setup and mail merge, which combines a main document with a data source to produce many personalised letters. Excel offers formulas and functions, sorting, filtering, charts and pivot tables, and every formula starts with the equals sign. PowerPoint offers text, images, charts, transitions, animations and slide layouts. The keyboard shortcuts that recur most in exams are Ctrl+C, Ctrl+V, Ctrl+X, Ctrl+Z, Ctrl+Y, Ctrl+A, Ctrl+S, Ctrl+P, Ctrl+B, Ctrl+I and Ctrl+U, and in Excel Ctrl+Arrow and F2. The file extensions .docx, .xlsx, .pptx and .accdb are also asked directly, and older versions used .doc, .xls and .ppt.
Types of Questions Asked
The most common pattern asks which application is used for a given task. The second asks the default file extension of an application. The third asks the full form of a function or shortcut. The fourth asks a feature of Word, Excel or PowerPoint. The fifth asks which view or menu holds a particular command. Direct identification questions take most of the marks.
Steps to Solve an MS Office Question
First, read the question and see which application it names or hints at. Second, if it asks for a task, recall the one-line purpose of each application and match it. Third, if it asks for an extension, remember .docx, .xlsx, .pptx and .accdb for the current versions. Fourth, if it asks for a shortcut, picture the key and the action it performs. Fifth, remove options that belong to a different application. Finally, check the full form word by word, because one wrong word hides the correct answer.
Examination Trends
In Assam recruitment papers the identification of the correct application, default extensions, common shortcuts and the basic features of Word, Excel and PowerPoint appear most often, followed by PowerPoint views, Excel functions and Access objects. Questions are short and single fact based, so steady revision is enough. The same shortcuts and extensions repeat year after year, which makes this section quick to secure.
Common Mistakes to Avoid
- Do not mix the extensions; .xlsx is Excel, not Word.
- Do not forget that a formula in Excel must begin with the equals sign.
- Do not confuse a workbook with a worksheet, since a workbook holds worksheets.
- Do not call PowerPoint a word processor or Word a spreadsheet.
- Do not confuse the full forms; I in IF, SUM and AVERAGE means exactly what it says.
- Do not overlook Access, which is the database application of the suite.
How to Prepare This Topic
Make a table of the five applications with their purpose and their default extension in three columns, and learn it by heart. Next write the twelve most common shortcuts with their actions and revise them aloud. Then list the main features of Word, Excel and PowerPoint, and against each write one situation in which it is used. Finally, learn the basic Excel functions and the PowerPoint views.
Attempt twenty questions a day and keep a register of the extensions, functions and shortcuts you got wrong, because the same items recur. Revise the difference between a workbook and a worksheet, and between Word and Excel, aloud, since these are the most common traps. In the last week revise only the tables and the register, and the section will be ready.
Quick Revision Tips
- Word for text, Excel for numbers, PowerPoint for slides, Access for databases.
- Extensions: .docx, .xlsx, .pptx, .accdb.
- Every Excel formula begins with the equals sign.
- Ctrl+C copy, Ctrl+V paste, Ctrl+Z undo, Ctrl+S save.
- A workbook contains worksheets; a worksheet contains cells.
Final Revision Note
On the last day, revise the applications-and-extensions table, the shortcuts list and the Excel functions, then attempt a timed set of twenty questions. For every wrong answer, write the exact item that was missed. MS Office questions reward clear associations, and a candidate who has them answers fast and gains easy marks.
Frequently Asked Questions
Which MS Office application is used to create slides?
MS PowerPoint is used to create presentations made of slides.
What is the default file extension of a Word document?
The default extension of a Word 2007 and later document is .docx, while older versions used .doc.
Which shortcut is used to undo the last action?
Ctrl+Z is used to undo the last action, and Ctrl+Y redoes it.
What is the difference between a workbook and a worksheet?
A workbook is the whole Excel file, and a worksheet is a single grid of rows and columns inside it.
Which application is used to store records and run queries?
MS Access is the database application of MS Office, used to store records in tables and run queries.