Microsoft Forms for Surveys with Automatic Chart Summaries
An HR manager needs to collect anonymous feedback from employees about a new benefits policy. They want the responses to be automatically summarized into charts and graphs. Which Microsoft 365 app is best suited for this task?
Quick Answer
Microsoft Forms is the app best suited to this task because it is purpose-built for exactly this pattern — creating a survey, offering a built-in anonymous response option so respondents' identities are not tied to their answers, and automatically generating charts and graphs summarising the collected responses without any manual data processing. The anonymous response setting is a specific, native Forms feature rather than something requiring custom configuration, which matters directly for a benefits-policy feedback survey where honest input depends on employees trusting their responses cannot be traced back to them. Once responses come in, Forms' built-in analytics view presents them as visual summaries in real time, updating automatically as new responses arrive, which removes any need to export data into a separate tool like Excel or Power BI just to see aggregate trends. Any scenario combining anonymous survey collection with automatic visual summarisation is testing recognition of Forms as the lightweight, purpose-built answer rather than a more general data-collection or analytics tool.
⚠ Common exam trap
It's easy for candidates to confuse Microsoft Forms with Microsoft Power BI, assuming that any charting or graphing requirement must involve a dedicated analytics tool, but Forms handles simple survey summarization natively without needing Power BI's complexity.
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 support for anonymous responses and automatic generation of charts and graphs from collected data. The HR manager can create a feedback form, enable anonymous submissions, and view real-time summaries with visualizations directly within Forms, without needing additional tools.
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
Forms includes built-in anonymous response options and automatically generates charts from responses.
- ✗
Microsoft Excel
Why it's wrong here
Excel can store and chart data but requires manual setup and does not natively support anonymous surveys or automatic chart generation from form submissions.
- ✗
Microsoft Sway
Why it's wrong here
Sway is for creating interactive presentations and newsletters, not for surveys or data collection.
- ✗
Microsoft Power BI
Why it's wrong here
Microsoft Power BI is incorrect because it is a business intelligence tool designed for analysing and visualising *existing* datasets, not for *collecting* new input directly from users via a form or survey. The scenario specifically requires a method to gather anonymous feedback. It is tempting due to its strong capabilities in automatically summarising data into charts and graphs, and would be the ideal choice if the feedback had already been collected by another application and needed advanced visual reporting.
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
One of 217 original MS-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way 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. An HR manager needs to collect feedback from employees about a new wellness program. The manager wants to create a simple survey with multiple-choice questions and have the responses automatically visualized in charts. Which Microsoft 365 app is best suited for this task?
easy- A.Microsoft Excel
- ✓ B.Microsoft Forms
- C.Microsoft Word
- D.Microsoft Teams
Why B: Microsoft Forms is specifically designed for creating surveys, quizzes, and polls with automatic response collection and built-in chart visualization. It allows the HR manager to quickly add multiple-choice questions and instantly see aggregated results as charts without any manual setup.
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.