MS-900 Describe Microsoft 365 apps and services Practice Question
A user wants to create a dashboard that visualizes sales data from multiple sources in real time. Which Microsoft 365 app should they use?
⚠ Common exam trap
MS-900 often tests the distinction between apps for data entry (Forms, Lists) and data visualization (Power BI), and candidates may confuse Excel's charting with Power BI's interactive dashboards.
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
✓
Power BI
Power BI is Microsoft's business analytics service that enables users to create interactive dashboards and reports from multiple data sources, with real-time data refresh capabilities. It is designed for data visualization and business intelligence, making it the appropriate tool for this requirement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Excel
Why it's wrong here
Excel visualises data but refreshes from multiple sources on a scheduled or manual basis, not continuously in real time, and shared dashboards lack live streaming ingestion. It suits periodic reporting and modelling where near-real-time refresh is acceptable.
- ✗
Microsoft Lists
Why it's wrong here
Microsoft Lists stores structured records and offers list views, not real-time aggregation of multiple external data sources into visual dashboards. It fits tracking issues, assets or inventory within a team, where tabular list management rather than cross-source analytics is the requirement.
- ✗
Microsoft Forms
Why it's wrong here
Microsoft Forms collects responses through surveys and quizzes, then stores them for review; it neither connects to multiple external data sources nor renders live dashboards. It fits gathering structured input from people, such as feedback or registration, not sales analytics.
- ✓
Power BI
Why this is correct
Power BI connects to multiple data sources and refreshes datasets on schedules or via streaming, rendering live dashboards that update without manual intervention. This satisfies the real-time, multi-source visualisation requirement, whereas Excel and Power Apps lack native streaming dashboards across heterogeneous sources.
Go deeper
Related to this question
Learn chapter
Microsoft Defender for Business
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.
Key term
User
A user is any person, system, or device that interacts with an IT service, resource, or identity system, typically authenticated through credentials and authorized to perform specific actions.
About these practice questions
One of 794 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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.