MS-900 Describe Microsoft 365 apps and services Practice Question
An HR manager needs to collect employee feedback on a new policy. They want to create a short survey that anonymizes responses and provides automatic charts summarizing the results. Which Microsoft 365 app is best suited for this task?
⚠ Common exam trap
A common mix-up: candidates confuse Microsoft Lists as a survey tool because it can collect data via forms, but Lists lacks anonymous response settings and automatic charting, which are core to Forms.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Microsoft Forms
Microsoft Forms is the correct choice because it is specifically designed for creating surveys and quizzes with built-in anonymous response settings and automatic chart generation. The HR manager can enable 'Record name' to be off for anonymity, and Forms automatically visualizes results with pie charts, bar graphs, and summary data without manual setup.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Microsoft Lists
Why it's wrong here
Microsoft Lists is a data tracking and organization app designed to create structured lists (e.g., assets, projects, issues) with custom columns, views, and formatting. While it can capture manually entered responses, it lacks a built-in survey distribution mechanism, anonymous response handling, and automatic chart generation, so it is not a practical tool for collecting and summarizing employee feedback on a new policy.
- ✓
Microsoft Forms
Why this is correct
Microsoft Forms is purpose-built for creating surveys and questionnaires with multiple question types (choice, rating, text), branching, and anonymous response options. It automatically compiles responses into real-time summary charts, supports exporting results to Excel, and can be embedded in Teams or SharePoint, making it the ideal tool for an HR manager to efficiently gather and analyze feedback.
- ✗
Microsoft Sway
Why it's wrong here
Sway is a digital storytelling tool for producing interactive newsletters, presentations, and reports, with a focus on visual layout and narrative flow rather than data collection. It does not provide a structured survey interface, nor does it offer a mechanism to collect or aggregate individual responses, so it cannot serve as the feedback collection tool for the new policy scenario.
- ✗
Microsoft Excel
Why it's wrong here
Excel is a spreadsheet application for storing, calculating, and visualizing data, but it is not a dedicated survey collection tool. It lacks native support for anonymous response submission, requires manual assembly of individual emailed copies or data entry, and offers no automatic charting of collected feedback, making it inefficient and error-prone compared to Microsoft Forms for this HR scenario.
Go deeper
Related to this question
Learn chapter
Benefits of Microsoft Cloud
Key term
Microsoft 365
Microsoft 365 is a subscription-based cloud service from Microsoft that combines productivity tools like Office apps with security, device management, and online storage.
Key term
Microsoft Forms
Microsoft Forms is a cloud-based tool for creating surveys, quizzes, and polls to collect data and feedback.
About these practice questions
This MS-900 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on MS-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A user needs to create a form to collect feedback from customers. The responses should be automatically stored in an Excel spreadsheet in OneDrive. Which Microsoft 365 app should they use?
easy- A.Microsoft Lists
- ✓ B.Microsoft Forms
- C.Microsoft Power Apps
- D.Microsoft Sway
Why B: Microsoft Forms is the correct app because it is specifically designed for creating surveys, quizzes, and feedback forms, and it natively integrates with Excel to automatically store responses in a spreadsheet hosted on OneDrive. This meets the user's requirement without additional configuration or custom development.
Variation 2. A manager wants to quickly create a survey to collect employee feedback on a new policy. The survey must automatically store responses in an Excel spreadsheet and trigger an email notification when a response is submitted. Which Microsoft 365 service should the manager use?
medium- ✓ A.Microsoft Forms
- B.Microsoft Lists
- C.Microsoft Power Apps
- D.Microsoft SharePoint
Why A: Microsoft Forms is the correct choice because it is designed specifically for creating surveys and quizzes, and it natively integrates with Excel to automatically store responses in a spreadsheet. Additionally, Forms supports Power Automate flows out of the box, allowing you to trigger an email notification whenever a new response is submitted, meeting both requirements without custom development.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This MS-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the MS-900 exam.