MS-900 Describe Microsoft 365 apps and services Practice Question
A sales team wants to maintain a shared list of high-priority leads with custom columns for company name, contact person, deal value, and stage. Team members need to update the list in real time and view the change history. Which Microsoft 365 app should they use?
⚠ Common exam trap
The trap is choosing Excel because it is familiar for tabular data; the exam expects you to recognize that shared lists with custom columns and version history are the domain of Microsoft Lists.
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 M365 app purpose-built for shared, structured lists with custom columns, real-time co-authoring, and built-in version history. It supports column types such as text, choice, person, currency, and date, and integrates with Teams and SharePoint. This matches the sales team's need for a shared, editable lead tracker with change history.
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 is the dedicated list management app in Microsoft 365, purpose-built for tracking structured data like a high-priority sales target list. It offers rich column types (choice, person, date), custom views, conditional formatting, item-level versioning, and real-time co-authoring. Because Lists stores data in SharePoint but exposes a simplified UI, it gives the sales team immediate collaboration without requiring a full SharePoint site design.
- ✗
Microsoft Excel
Why it's wrong here
Excel is a spreadsheet application optimized for numerical analysis, formulas, and charting, not for maintaining structured team lists. While workbooks can be stored on OneDrive or SharePoint and co-authored, they operate at the file level—version history and permissions are applied to the whole file, not individual rows or items. Excel also lacks built-in list features such as choice/person columns, validation workflows, and shared views, so it is less robust for a continuously updated priority list.
- ✗
Microsoft SharePoint
Why it's wrong here
SharePoint underpins many Microsoft 365 data services, but it is a broader document management and intranet platform, not a focused list-creation tool. A SharePoint list exists within a site, requiring site navigation and manual configuration of list settings. Microsoft Lists is the modern, standalone experience layered on that same underlying list engine, steering users straight to the functionality they need—so choosing SharePoint directly would be the roundabout path.
- ✗
Microsoft Teams
Why it's wrong here
Microsoft Teams is a communication and collaboration hub centered on chat, channels, meetings, and app integration; it does not natively provide data-authoring tools. You can add a Microsoft Lists tab to a Teams channel for convenient access, but the list itself is created and stored in Lists/SharePoint, not in Teams. For a sales team to 'maintain a shared list,' Teams serves only as a container, lacking the column schema, version history, and custom views that Lists offers.
Go deeper
Related to this question
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.