MS-900 Describe Microsoft 365 apps and services Practice Question
A sales manager wants to create a visual representation of the sales pipeline, including stages, deal values, and win probability. They want to share this interactive chart with the team via a web link that updates automatically from the underlying data in Microsoft Lists. Which Microsoft 365 app should they use?
⚠ Common exam trap
MS-900 often tests the confusion between Excel's charting capabilities and Power BI's dedicated BI/auto-refresh features, tempting candidates to pick Excel for 'visualization' questions.
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
Power BI is Microsoft's dedicated business intelligence and data visualization service, designed to build interactive dashboards and reports from data sources such as Microsoft Lists, Excel, and SharePoint. It supports automatic refresh schedules and can publish reports to a web link (Publish to web) that updates as the underlying data changes. This directly satisfies the sales manager's requirement for an interactive, auto-updating pipeline visualization.
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 Power BI
Why this is correct
Power BI is the correct choice because it has a native Microsoft Lists connector that lets you ingest pipeline data directly into a data model, then build interactive dashboards with slicers, drill-throughs, and cross-filtering. Once published to the Power BI Service, the report is accessible via a secure web link, and a scheduled refresh can automatically pull updated list data without manual exports or file re-uploads.
- ✗
Microsoft Excel
Why it's wrong here
Excel can create charts from list data, but it lacks native web-publishing with live sync from Microsoft Lists; sharing requires manual file uploads or static exports, so the automatic, interactive web link requirement is unmet. It is tempting because Excel excels at building detailed pipeline charts and calculating win probabilities locally, and would be correct if the manager only needed a static report or a shared workbook without live web interactivity.
- ✗
Microsoft Forms
Why it's wrong here
Microsoft Forms is designed solely for creating surveys, quizzes, and polls; it captures responses into an associated data table but provides no dashboarding, charting, or pipeline visualization capabilities. It cannot connect to an existing Microsoft Lists dataset as a source, nor can it publish an interactive, automatically refreshing web view of sales pipeline metrics — so it fails every functional requirement of the scenario.
- ✗
Microsoft SharePoint
Why it's wrong here
SharePoint can display Microsoft Lists data through standard list views and web parts, and it offers only basic charts such as column or pie charts with minimal interactivity. Those charts are limited to simple aggregations, lack drill-down and cross-filtering, and are not equivalent to the advanced analytical visuals and managed web publishing that Power BI provides; therefore SharePoint alone cannot satisfy the manager's need for an interactive, refreshable web dashboard.
Go deeper
Related to this question
Learn chapter
Microsoft Migration Tools: SharePoint and Exchange
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
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 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.