MS-900 Describe Microsoft 365 apps and services — 50 Questions

Question 1

A marketing team needs to collaboratively create and edit documents in real time, share files securely, and track version history. Which Microsoft 365 service should they primarily use?

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it is designed for team collaboration with real-time co-authoring, granular permission-based file sharing, and built-in version history that tracks every change. Unlike OneDrive, which is optimized for individual file storage and sharing, SharePoint provides a centralized team site where multiple users can simultaneously edit documents and manage versions at the site or library level.

Answer

Microsoft Teams

Answer

OneDrive for Business

Answer

Microsoft Viva Engage

Question 2

A global sales team uses Microsoft Teams for communication. They need to automate business workflows such as sending approval requests when a new lead is created in Dynamics 365. Which Microsoft 365 service should they integrate with Teams?

Accepted Answer

Power Automate. Power Automate (Option B) is the correct service because it is designed specifically for automating business workflows across Microsoft 365 and third-party services. When a new lead is created in Dynamics 365, a Power Automate flow can trigger an approval request in Teams, enabling seamless process automation without custom code.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 3

A project team uses Microsoft Teams and wants to create a shared space where they can track tasks, deadlines, and assign work items without leaving Teams. Which Microsoft 365 app should be integrated into Teams for this purpose?

Accepted Answer

Microsoft Planner. Microsoft Planner is the correct choice because it provides a lightweight, Kanban-style task management solution that integrates directly into Microsoft Teams via the Planner tab. This allows the project team to create, assign, and track tasks with deadlines and progress indicators without leaving the Teams interface, fulfilling the requirement for a shared workspace for work items.

Answer

Microsoft Project Online

Answer

Microsoft To Do

Answer

Microsoft Lists

Question 4

A manager needs to create a custom dashboard that visualizes sales data from multiple data sources in real-time. Which service should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is specifically designed for creating interactive, real-time dashboards that aggregate data from multiple sources, including databases, cloud services, and streaming data. It provides live tile updates and direct query capabilities, enabling real-time visualization of sales data without manual refresh.

Answer

Excel

Answer

Power Apps

Answer

SharePoint

Question 5

A marketing team needs to create a visually rich newsletter that includes dynamic content from a SharePoint list, such as upcoming events and product images. Which Microsoft 365 app is specifically designed for creating interactive newsletters and presentations?

Accepted Answer

Microsoft Sway. Microsoft Sway is specifically designed for creating interactive, visually rich newsletters and presentations that can pull dynamic content from SharePoint lists, such as upcoming events and product images. It uses a web-based canvas with responsive design and supports embedding live data via SharePoint connectors, making it ideal for marketing teams needing dynamic, shareable content without coding.

Answer

Microsoft Forms

Answer

Microsoft Stream

Answer

Microsoft Microsoft Viva Engage

Question 6

A project manager wants to schedule a meeting with team members to discuss project progress. They need to find a time that works for everyone based on their calendars. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Outlook. Microsoft Outlook includes a scheduling assistant that displays the free/busy information of attendees' calendars, allowing the project manager to find a mutually available time slot. This feature is specifically designed for coordinating meetings across an organization using Exchange Online calendar data.

Answer

Microsoft Teams

Answer

Microsoft Bookings

Answer

Microsoft Shifts

Question 7

A project manager needs a centralized location to store all project documents, assign tasks to team members, and track project milestones. The solution must integrate with Microsoft Teams and allow real-time co-authoring. Which Microsoft 365 service should they use?

Accepted Answer

Microsoft SharePoint Online. SharePoint Online provides document libraries for storing files with real-time co-authoring, plus lists for tracking tasks and milestones. It integrates deeply with Teams through tabs. Microsoft Planner is task-focused but does not natively store documents. Project Online is more complex and expensive. To Do is for personal tasks.

Answer

Microsoft Planner

Answer

Microsoft Project Online

Answer

Microsoft To Do

Question 8

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?

Accepted Answer

Microsoft Power BI. Microsoft Power BI allows creation of interactive dashboards and reports that can connect to various data sources, including Microsoft Lists. It can publish a web-accessible interactive report that automatically refreshes. Excel charts are static unless published as a web workbook, but they lack interactivity and automatic refresh from Lists without complex setup. SharePoint lists display data in tabular format, not interactive charts. Forms is for surveys.

Answer

Microsoft Excel

Answer

Microsoft Forms

Answer

Microsoft SharePoint

Question 9

A team is working on a project proposal that requires simultaneous input from multiple team members. They need to see each other's changes in real time and have a full revision history. Which two Microsoft 365 applications support this capability? (Choose two.)

Accepted Answer

Word for the web. Word for the web and Excel for the web support real-time co-authoring, allowing multiple users to edit the same document simultaneously with changes visible to all collaborators within seconds. They also maintain a full revision history via versioning, enabling users to view, restore, or compare previous versions. This capability is built on the Office Online Server infrastructure and uses WebSocket-based synchronization for low-latency updates.

Answer

Outlook on the web

Answer

OneNote for Windows 10

Question 10

A communications manager wants to create an interactive monthly newsletter that includes embedded videos, images, and links to SharePoint documents. The newsletter should be viewable on any device without needing to install an app. Which Microsoft 365 app is best suited for this?

Accepted Answer

Microsoft Sway. Microsoft Sway is a presentation and storytelling app designed to create interactive, web-based content that can include multimedia such as videos, images, and embedded links. It adjusts automatically to any screen size and is accessible via a browser without installation. PowerPoint is mainly for slideshows and offline viewing. SharePoint is a document management and collaboration platform, not a content authoring tool. Stream is a video service, not suitable for a newsletter.

Answer

Microsoft PowerPoint

Answer

Microsoft SharePoint

Answer

Microsoft Stream

Question 11

A project team needs a centralized workspace that includes a shared calendar, a document library for storing deliverables, a task list with assignments, and the ability to have threaded discussions about each item. They want a solution that is available out of the box in Microsoft 365 and integrates with Microsoft Teams. Which service should they use?

Accepted Answer

SharePoint team site. A SharePoint team site provides a team-oriented workspace with a document library for files, a shared calendar, a tasks list, and a discussion board for threaded conversations. It can be added as a tab in Teams. Teams alone does not include all these features natively.

Answer

Microsoft Teams

Answer

Microsoft Viva Engage

Answer

Microsoft Planner

Question 12

A project manager needs a digital notebook where team members can capture meeting notes, add ink drawings using a stylus, and share content in real time. The solution must integrate with Microsoft Teams and support tagging for easy search. Which Microsoft 365 app is best suited?

Accepted Answer

OneNote. OneNote is the best fit because it provides a digital notebook with support for ink drawings via stylus, real-time collaboration, and tagging for search. It integrates natively with Microsoft Teams through the OneNote tab, allowing team members to capture and share meeting notes directly within Teams channels.

Answer

Word Online

Answer

SharePoint Wiki

Answer

Microsoft Lists

Question 13

A project manager wants to create a visual dashboard that tracks project tasks, deadlines, and progress. The dashboard should pull data from a Microsoft List and update in real time. Which Microsoft 365 app is best suited for building this interactive dashboard?

Accepted Answer

Power BI. Power BI is the correct choice because it is designed to create interactive, real-time dashboards with live data connectivity. It can connect directly to a Microsoft List as a data source and refresh automatically, enabling real-time tracking of project tasks, deadlines, and progress with visualizations like charts and gauges.

Answer

Microsoft Lists

Answer

SharePoint Online

Answer

Microsoft Forms

Question 14

A marketing team needs to create a professional-looking newsletter that includes embedded videos, images, and links to documents. The newsletter should be viewable on any device and allow team members to collaborate on the content. Which Microsoft 365 app is best suited for this purpose?

Accepted Answer

Sway. Sway is the correct choice because it is specifically designed for creating interactive, web-based reports and newsletters that can embed videos, images, and links to documents. It provides responsive design that automatically adapts to any device, and it supports real-time collaboration through sharing a link, allowing team members to co-author content.

Answer

Word Online

Answer

Publisher

Answer

OneNote

Question 15

A project team needs a central location to store and collaborate on project documents, with version history, co-authoring, and the ability to share files securely with external partners. Which Microsoft 365 service provides these capabilities?

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it provides a centralized document library with version history, real-time co-authoring via Office Online integration, and granular external sharing controls through secure links or direct invitations. These capabilities align directly with the project team's need for collaborative document management and secure external partner access.

Answer

Exchange Online

Answer

Microsoft Stream

Answer

Microsoft Viva Engage

Question 16

A product design team wants to conduct remote brainstorming sessions where participants can draw, write sticky notes, and add images on a shared canvas in real time. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Whiteboard. Microsoft Whiteboard is the correct choice because it provides a free-form digital canvas that supports real-time collaboration, including drawing, sticky notes, and image insertion. This directly meets the requirement for remote brainstorming sessions where participants need to interact on a shared canvas simultaneously.

Answer

Microsoft To Do

Answer

Microsoft Forms

Answer

Microsoft Planner

Question 17

An HR manager needs to collect feedback from employees about a new wellness program. The manager wants to create a simple survey with multiple-choice questions and have the responses automatically visualized in charts. Which Microsoft 365 app is best suited for this task?

Accepted Answer

Microsoft Forms. Microsoft Forms is specifically designed for creating surveys, quizzes, and polls with automatic response collection and built-in chart visualization. It allows the HR manager to quickly add multiple-choice questions and instantly see aggregated results as charts without any manual setup.

Answer

Microsoft Excel

Answer

Microsoft Word

Answer

Microsoft Teams

Question 18

A project manager needs to collect weekly status reports from team members. They want to create a simple form where team members can submit updates, and the responses should automatically be stored in an Excel spreadsheet. The manager also wants a notification sent to their email when a new response is submitted. Which Microsoft 365 app(s) should be used together?

Accepted Answer

Microsoft Forms only. Microsoft Forms can create a simple form for collecting weekly status reports. It natively supports email notifications for each response (via Settings > Email notification) and automatically writes responses to an Excel spreadsheet (via Open in Excel). Therefore, no additional app is required, making option B correct.

Answer

Microsoft Forms and Microsoft Power Automate

Answer

Microsoft Lists and Power Automate

Answer

Microsoft Excel only

Question 19

A sales team needs a mobile-friendly solution to track and manage sales leads, meetings, and customer communications in a single interface. The solution should integrate with Outlook and include basic customer relationship management (CRM) capabilities. Which Microsoft 365 app is designed for this purpose?

Accepted Answer

Microsoft Dynamics 365 Sales. Microsoft Dynamics 365 Sales (formerly Dynamics CRM) provides comprehensive sales management, including lead tracking, opportunity management, and integration with Outlook. While the question mentions 'Microsoft 365 app', Dynamics 365 is part of the broader Microsoft business applications family but closely integrated. However, for a 'Microsoft 365 app' that does this, the built-in app is 'Dynamics 365 Sales'. Some may think of 'Microsoft Lists' or 'Outlook', but those lack CRM capabilities. Alternatively, 'Microsoft Relationship Sales'? The question is straightforward: Dynamics 365 is the CRM solution. But note that the domain is 'apps and services', which includes Dynamics 365 as a service. The correct answer is Dynamics 365 Sales.

Answer

Microsoft Lists

Answer

Microsoft Viva Sales

Answer

Microsoft To Do

Question 20

A team of financial analysts needs to collaboratively build a complex budget model that includes data from multiple sources. They require real-time co-authoring, advanced formulas, and the ability to create custom charts. Which Microsoft 365 app is best suited for this task?

Accepted Answer

Microsoft Excel. Microsoft Excel is the correct choice because it is designed for complex numerical modeling with advanced formulas, real-time co-authoring via OneDrive or SharePoint, and custom chart creation. The team's requirements for multi-source data integration, collaborative editing, and analytical visualization align directly with Excel's core capabilities, unlike the other apps which lack these features.

Answer

Microsoft Word

Answer

Microsoft PowerPoint

Answer

Microsoft OneNote