MS-900 Describe Microsoft 365 apps and services Practice Question
A marketing team wants to quickly create a visually appealing report from data stored in Excel and share it with stakeholders via a web browser. Which Microsoft 365 app should they use?
⚠ Common exam trap
Test-takers frequently choose Microsoft Excel because they think it can create charts and share them via OneDrive or SharePoint, but they overlook that Power BI is the dedicated tool for interactive, browser-based reporting with advanced visualization and sharing capabilities.
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 Power BI
Microsoft Power BI is the correct choice because it is designed specifically for creating interactive, visually appealing reports and dashboards from data sources like Excel. It allows users to publish these reports to the Power BI service, where stakeholders can access them via a web browser without needing to install any software.
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 it's wrong here
Microsoft Forms is a lightweight tool for building surveys, quizzes, and polls; it stores individual responses and can render basic per-question charts, but it lacks a reporting canvas, cross-filtering, or a data model. It cannot create multi-visual, interactive reports shared as a dynamic web app, so it is not the right tool for this scenario.
- ✗
Microsoft Stream
Why it's wrong here
Microsoft Stream is an enterprise video hosting and sharing service, focused on upload, live events, captions, and access controls. It does not include data connections, query logic, or visualization capabilities; any report-like content would need to be pre-built elsewhere or embedded as a video, so it cannot be used to create an interactive report from scratch.
- ✗
Microsoft Excel
Why it's wrong here
Excel is a general-purpose spreadsheet with charts, pivot tables, and slicers, and it can be viewed in a browser, but it is not a purpose-built reporting platform. Building a polished, interactive dashboard in Excel requires manual layout and pivot configuration, and sharing it via the web involves file-based permissions rather than a managed BI service with a live semantic model. For quick, governed, interactive reports, Power BI is the intended tool.
- ✓
Microsoft Power BI
Why this is correct
Power BI is Microsoft's dedicated business intelligence tool for turning data into interactive, visually rich reports. Users can connect to dozens of data sources, build cross-filtering visuals, add drilldowns, and publish to the Power BI service, where colleagues access the report in a browser or mobile app. This directly matches the team's need to quickly create and share an appealing, interactive report.
Go deeper
Related to this question
Learn chapter
Cross-Tenant Access Policies in Entra ID
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
Power BI
Power BI is a Microsoft business analytics tool that transforms raw data into interactive visual reports and dashboards for informed decision-making.
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.