MS-900 Describe Microsoft 365 apps and services Practice Question
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?
⚠ Common exam trap
A common mix-up: candidates confuse Microsoft Lists with Forms because both can collect data, but Lists is a structured data repository, not a survey tool, and lacks the automatic Excel storage and email trigger capabilities that Forms offers through its native Power Automate integration.
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 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.
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 Forms
Why this is correct
Microsoft Forms is the correct choice because it provides an out-of-the-box survey creation interface with ready-to-use question types, branching, and themes, enabling an employee feedback survey to be built in minutes. Responses are automatically collected into an Excel workbook for immediate analysis, and the built-in Power Automate integration allows you to trigger an email alert to a manager or HR whenever a new response is submitted, without writing any code.
- ✗
Microsoft Lists
Why it's wrong here
Microsoft Lists is designed for structured data tracking and organization, such as issue logs, asset inventories, or project tasks, not for creating interactive surveys. While you could manually build a list with columns labeled as survey questions, there is no native form-style UI for respondents to fill in, and responses would not automatically flow to an Excel file; you would need significant manual setup or custom Power Automate workflows to simulate what Forms does natively.
- ✗
Microsoft Power Apps
Why it's wrong here
Microsoft Power Apps is a low-code platform for building custom business applications with custom data sources, screens, and logic, which is far more complex than quickly creating a survey. You would need to design the form interface, set up a data source like Dataverse or SharePoint, and create custom connectors to send email notifications on submission, requiring development effort and a learning curve. While it can achieve the end result, it is not the quickest or most efficient tool for a simple employee feedback survey.
- ✗
Microsoft SharePoint
Why it's wrong here
SharePoint lacks the built-in capability to automatically store survey responses directly into an Excel spreadsheet and trigger an email notification upon each submission; it stores data in lists, not Excel files, and requires Power Automate or custom workflows to send notifications. It is tempting because SharePoint is often used for document management and team collaboration, and in a scenario requiring a central repository for shared documents or a team site for policy discussion, it would be the correct choice.
Go deeper
Related to this question
Learn chapter
Cloud Service Types for MS-900
Key term
Power Automate
Power Automate is a cloud-based service from Microsoft that lets you create automated workflows between apps and services without writing code.
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.
About these practice questions
Courseiva writes every MS-900 question from scratch — 217 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
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.