Describe Microsoft 365 apps and services →mediumMultiple ChoiceObjective-mapped

MS-900 Describe Microsoft 365 apps and services Practice Question

A sales manager needs a visual tool to track the sales pipeline with stages, deal values, and assigned team members. The team should be able to update the board in real time and see changes instantly. Which Microsoft 365 app is most suitable?

⚠ Common exam trap

It's easy for candidates to confuse Microsoft Planner's task board with a sales pipeline tool, but Planner lacks custom fields for deal values and real-time data updates across multiple users, making Lists the correct choice for this specific requirement.

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 Lists

Microsoft Lists is the most suitable app because it provides a customizable, real-time collaborative board view that can track sales pipeline stages, deal values, and assigned team members. Lists supports real-time co-authoring and instant updates via SharePoint, making it ideal for a visual, always-current sales tracking tool without requiring a full CRM system.

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 this is correct
Microsoft Lists provides a visual, web-based tracking tool by letting you create a list with custom columns for deal stage, value, and owner, and then switch to a Board or Gallery view to display records as cards that move between stages. Because each list is backed by SharePoint, edits sync in real time and team members can see the pipeline update immediately. You retain the robustness of a data table rather than a simple task card, so monetary values, rollups, and filtering are natively supported.
✗
Microsoft Dynamics 365 Sales
Why it's wrong here
Microsoft Dynamics 365 Sales is a comprehensive customer relationship management (CRM) suite with lead scoring, opportunity management, marketing automation, and customer service modules, far exceeding the requirement for a simple pipeline visual. Adopting it solely for pipeline tracking would require separate Dynamics licensing and substantial configuration because it integrates with back-office processes like Power Platform and Dataverse. For a sales manager who just needs a shared, lightweight view of deals and stages, Dynamics 365 is an over-scoped tool that introduces unnecessary cost and administrative overhead.
✗
Microsoft Planner
Why it's wrong here
Microsoft Planner is optimized for task management: it organizes work into buckets and cards with checklists, assignments, and due dates, but it does not support custom currency columns, calculated values, or deal stage metadata. Cards in Planner represent action items and responsibilities, not records with monetary amounts, so you cannot sort or roll up the sales pipeline by deal value. Any attempt to track monetary pipeline in Planner forces textual workarounds and obscures the numeric status that a pipeline board needs.
✗
Microsoft Excel
Why it's wrong here
Microsoft Excel can hold pipeline data as rows with stage and amount columns, but there is no native board or gallery view to visualize a sales funnel; you would have to manually build a dashboard with formulas or pivot tables. Collaboration is hampered because a shared workbook frequently leads to conflicting edits without page-level locking, and Excel's default UI is a grid rather than an interactive kanban. Lists provides a purpose-built visual layer and real-time concurrency that Excel does not offer in a standard M365 workflow.

Go deeper

MS-900 Describe Microsoft 365 apps and services Practice Question

Why each option matters

Option-by-option breakdown

Related to this question