MS-900 Describe Microsoft 365 apps and services Practice Question
Which TWO Microsoft 365 services can be used to create and manage custom forms for data collection, such as employee feedback surveys?
⚠ Common exam trap
It's easy for candidates to confuse Microsoft Lists or SharePoint Online as form-building tools because they can display or store form data, but they lack the native form creation and response management capabilities of Microsoft 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 purpose-built for creating custom forms, surveys, and quizzes, with automatic data collection into Excel Online. It provides a simple interface for designing feedback forms and viewing responses in real-time, making it the correct choice for employee feedback surveys.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SharePoint Online
Why it's wrong here
SharePoint Online is a collaboration and content-management platform, not a native form designer. While SharePoint list forms exist, they are auto-generated from list columns and require customization via Power Apps or InfoPath (deprecated) to change layout or logic. It can display Microsoft Forms responses or embed forms in pages, but creating a standalone form directly in SharePoint is not a built-in function.
- ✗
Microsoft Lists
Why it's wrong here
Microsoft Lists is a data-tracking application built on SharePoint lists, designed to organize information as structured lists. It provides a default entry form for adding list items, but that form is auto-generated from the list schema and cannot be designed, branded, or configured with branching, validation, or conditional logic. Lists can store form-submitted data when integrated with Power Apps or Microsoft Forms, but it is not a form creation service itself.
- ✓
Microsoft Forms
Why this is correct
Microsoft Forms is the dedicated survey and form builder in Microsoft 365, purpose-built for creating quizzes, polls, and data-collection forms. It provides an intuitive designer, branching rules, built-in response analytics, and automatic export of responses to an Excel Online workbook. Because it is natively designed for building and distributing forms, it is one of the two correct services that can directly create and manage forms.
- ✗
Excel Online
Why it's wrong here
Excel Online is a spreadsheet application focused on data calculation, analysis, and visualization. Although you can format cells and use data validation to simulate an input sheet, Excel Online does not provide a hosted, shareable form interface with a URL, response collection, or form analytics. Its primary role in the form lifecycle is consuming responses exported from Microsoft Forms or acting as a data source for Power Apps, not creating the form itself.
- ✓
Microsoft Power Apps
Why this is correct
Microsoft Power Apps is a low-code application platform that lets you build custom forms with full control over layout, branding, validation, and business logic. Forms created in Power Apps can connect to Dataverse, SharePoint, Excel, or hundreds of other data sources, making it suitable for line-of-business scenarios that require more than a simple survey. Because Power Apps can create and manage robust, data-connected user input forms, it is the second correct service for this question.
Go deeper
Related to this question
Learn chapter
Data Governance and Retention
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.