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 and surveys?
⚠ Common exam trap
It's easy for candidates to confuse Microsoft Lists or SharePoint Lists with form creation tools because they can display data in a form-like view, but they lack the native survey and data collection functionality that Microsoft 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 purpose-built for creating custom forms, surveys, and quizzes with automatic data collection into Excel Online. It provides a simple interface for designing forms, distributing them, and analyzing responses in real time, making it the primary tool for this task in Microsoft 365.
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 items such as issues, assets, or inventory. While it offers customizable column types and a default edit form for individual list items, it does not include a standalone form builder for creating surveys or quizzes with branching, logic, or response analytics. Hence, it does not satisfy the requirement of creating forms.
- ✓
Microsoft Forms
Why this is correct
Microsoft Forms is the dedicated service for building surveys, quizzes, and polls, providing a question editor, branching rules, and automatic result charts. It supports real-time response collection and can be embedded easily in Teams or SharePoint, making it the obvious choice for form creation. This service is purpose-built for the task described in the question.
- ✗
Excel Online
Why it's wrong here
Excel Online is primarily a spreadsheet application used for calculations, data analysis, and storing information in a grid. Although it supports data validation and cells, it lacks form-specific features like question types, response routing, quiz scoring, or a centralized response dashboard. Any form-like capability in Excel Online would require an integration with Microsoft Forms, so Excel Online itself is not a form-creation service.
- ✓
Power Apps
Why this is correct
Power Apps is a low-code development platform that enables users to build custom business applications, including canvas apps with data-entry forms and form controls. Because you can design flexible form layouts, connect to Dataverse or SharePoint, and gather responses, it is a valid tool for creating forms. However, it is broader than a simple survey tool, acting as an application builder rather than a dedicated survey engine.
- ✗
SharePoint Lists
Why it's wrong here
SharePoint Lists is a data-storage feature within SharePoint Online that organizes structured information into columns and items. Its default edit form is only a basic interface for adding or modifying list rows, not a full form design tool with survey question types, branching, or response analytics. It cannot create standalone forms like Microsoft Forms or Power Apps, making it incorrect for this scenario.
Go deeper
Related to this question
Learn chapter
Microsoft To Do and Task Management
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
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.