1. Which of the following is NOT a component of the MS Office Suite?

a) MS Word b) MS Excel c) MS PowerPoint d) MS Photoshop

Answer: d) MS Photoshop Explanation: MS Photoshop is not part of the Microsoft Office Suite. It is an image editing software developed by Adobe, while MS Word, Excel, and PowerPoint are part of the MS Office suite for document creation, spreadsheets, and presentations, respectively.

2. Which MS Office application is primarily used for data analysis and calculations?

a) MS Word b) MS Excel c) MS PowerPoint d) MS Outlook

Answer: b) MS Excel Explanation: MS Excel is used for data analysis, creating spreadsheets, and performing complex calculations using functions, charts, and tables.

3. What is the default file extension for an MS Word document in Office 2016 and later versions?

a) .doc b) .docx c) .txt d) .pdf

Answer: b) .docx Explanation: In MS Office 2007 and later versions, including Office 2016, Word files are saved with the .docx extension, which is based on XML format. The .doc extension was used in earlier versions.

4. Which of the following features is used in MS PowerPoint to apply movement to slides?

a) Animations b) Transitions c) Slide Show d) Layout

Answer: b) Transitions Explanation: Transitions in MS PowerPoint are used to add effects when moving from one slide to the next. Animations are applied to elements within a slide.

5. In MS Excel, which function is used to calculate the average of a range of cells?

a) SUM b) AVERAGE c) COUNT d) MIN

Answer: b) AVERAGE Explanation: The AVERAGE function calculates the mean of a range of numbers. SUM adds the numbers, COUNT counts the cells, and MIN finds the minimum value.

6. What is the purpose of the "Mail Merge" feature in MS Word?

a) To send emails from Word b) To combine multiple documents c) To create personalized letters, labels, or envelopes d) To merge formatting from different templates

Answer: c) To create personalized letters, labels, or envelopes Explanation: Mail Merge is used to create personalized documents such as letters or labels by combining a standard document template with a data source like a list of names and addresses.

7. Which MS Office application is primarily used for managing emails?

a) MS Word b) MS Excel c) MS PowerPoint d) MS Outlook

Answer: d) MS Outlook Explanation: MS Outlook is the email client in the MS Office Suite, used for managing emails, calendars, contacts, and tasks.

8. In MS Excel, which symbol is used to begin a formula?

a) = b) + c) ( d) /

Answer: a) = Explanation: In MS Excel, formulas always start with an equal sign (=), which tells Excel that the following characters represent a formula or function.

9. Which of the following is a valid file extension for an MS PowerPoint presentation?

a) .pptx b) .xlsx c) .docx d) .mdb

Answer: a) .pptx Explanation: MS PowerPoint presentations use the .pptx file extension in Office 2007 and later versions. The .xlsx extension is for Excel, and .docx is for Word.

10. Which feature in MS Word is used to track changes made to a document?

a) Spelling & Grammar b) Track Changes c) Word Count d) Document Inspector

Answer: b) Track Changes Explanation: The Track Changes feature in MS Word allows users to view and review changes made to the document, making it useful for editing and collaborating with others.