MS-900 Describe Microsoft 365 apps and services Practice Question
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?
⚠ Common exam trap
Watch out — candidates often confuse Microsoft Lists with Forms because both can collect data, but Lists requires manual setup for Excel export and lacks the automatic, one-click response-to-Excel workflow that Forms provides.
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 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.
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-management application for tracking structured information, such as project assets or inventory, using customizable columns, views, and sharing. While you can manually enter responses into a list or attach a custom Power Apps form to it, Lists does not provide a native, self-contained form interface with survey-style controls like branching or anonymous submission. It is therefore the wrong choice for quickly collecting feedback, because it centers on list maintenance rather than on the form-filling and response-collection workflow.
- ✓
Microsoft Forms
Why this is correct
Microsoft Forms is the correct tool because it is a purpose-built survey and quiz service within Microsoft 365, designed specifically for creating feedback forms with multiple question types, branching logic, and anonymous response settings. When users submit responses, Forms automatically compiles them into an Excel workbook, enabling easy analysis and visualization without requiring additional customization. Its straightforward workflow — create, distribute, collect, and export — directly matches the stated need to collect feedback from customers.
- ✗
Microsoft Power Apps
Why it's wrong here
Microsoft Power Apps enables users to build custom business applications with a canvas or model-driven design, allowing for sophisticated logic, data sources, and tailored user experiences. Although you could technically construct a form-based interface in Power Apps, it demands deliberate development effort, a dedicated environment, and appropriate licensing, making it disproportionately complex for a simple customer feedback form. The service is an application-development platform, not a lightweight form utility, so it is the wrong selection for this task.
- ✗
Microsoft Sway
Why it's wrong here
Microsoft Sway is an interactive storytelling tool used to design visually rich reports, presentations, and newsletters by combining text, images, videos, and embeddable content. It does not include any form fields, data-collection features, or response-tracking mechanisms, so it cannot capture customer feedback in a structured way. Because its purpose is digital storytelling rather than information gathering, Sway is not a viable option for creating a feedback form.
Go deeper
Related to this question
Learn chapter
External Sharing in SharePoint and OneDrive
Key term
Microsoft Forms
Microsoft Forms is a cloud-based tool for creating surveys, quizzes, and polls to collect data and feedback.
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 — 794 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.