MS-900 Describe Microsoft 365 apps and services Practice Test 2 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

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 2

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 3

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 4

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 5

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

Question 6

An IT administrator needs to ensure that all company-issued Windows 11 devices are configured with the latest security policies and that applications are deployed automatically. Which Microsoft 365 service should they use?

Accepted Answer

Microsoft Intune. Microsoft Intune is the correct choice because it is a cloud-based endpoint management solution that provides mobile device management (MDM) and mobile application management (MAM). It allows IT administrators to enforce security policies (e.g., BitLocker, Windows Defender Firewall, compliance rules) and automate application deployment to Windows 11 devices without requiring on-premises infrastructure. Intune integrates with Microsoft Entra ID for identity-based conditional access but is the primary service for device configuration and app deployment.

Answer

Microsoft Microsoft Entra ID

Answer

Microsoft Defender for Endpoint

Answer

Microsoft 365 Apps for enterprise

Question 7

A company is planning to migrate its collaboration tools to Microsoft 365. They need a solution for real-time document co-authoring, instant messaging, and video conferencing, all in one integrated platform. Which two Microsoft 365 services should they use? (Choose two.)

Accepted Answer

Microsoft SharePoint. Microsoft SharePoint is correct because it provides the document storage and versioning infrastructure that enables real-time co-authoring of documents (e.g., Word, Excel, PowerPoint) via the Office Online Server integration. Microsoft Teams is correct because it integrates instant messaging, persistent chat, and video conferencing (using the underlying Skype for Business Online technology) with SharePoint and OneDrive for seamless file sharing and co-authoring within the same interface.

Answer

Microsoft OneDrive

Answer

Microsoft Stream

Question 8

A training department needs to create interactive learning modules that include content pages, quizzes, and surveys. They also need to track completion and results for each learner. Which Microsoft 365 app should they use as the primary authoring tool for the quizzes and surveys?

Accepted Answer

Microsoft Forms. Microsoft Forms is the correct primary authoring tool because it is specifically designed for creating quizzes, surveys, and polls with automatic grading, branching logic, and result tracking. It integrates seamlessly with Microsoft Lists and Power Automate to record completion and results per learner, making it ideal for interactive learning modules.

Answer

Microsoft Stream

Answer

Microsoft Sway

Answer

Microsoft Viva Learning

Question 9

A marketing team needs to create a slide-based presentation that includes charts copied from an Excel spreadsheet and animated transitions. They also require the ability to collaborate in real-time with remote colleagues. Which Microsoft 365 app should they use?

Accepted Answer

PowerPoint. PowerPoint is the correct choice because it is specifically designed for creating slide-based presentations with rich media, including charts copied from Excel and animated transitions. It also supports real-time co-authoring via OneDrive or SharePoint, enabling multiple remote colleagues to edit simultaneously.

Answer

Word

Answer

Excel

Answer

Sway

Question 10

A sales team needs to manage leads, track customer interactions, and automate follow-up emails. They also want to collect customer feedback through surveys. Which two Microsoft 365 apps should they adopt for these requirements? (Choose two.)

Accepted Answer

Microsoft Dynamics 365 Sales. Microsoft Dynamics 365 Sales is a customer relationship management (CRM) application that provides lead management, customer interaction tracking, and automated follow-up email workflows. Microsoft Forms enables the creation and distribution of surveys to collect customer feedback, with responses automatically stored in Excel for analysis.

Answer

Microsoft Stream

Answer

Microsoft Planner

Question 11

A marketing team needs to create a short promotional video that includes screen recordings, webcam footage, and text overlays. Which Microsoft 365 app should they use to create this video?

Accepted Answer

Microsoft Clipchamp. Microsoft Clipchamp is the correct app because it is a built-in video editor in Microsoft 365 designed for creating and editing videos with features like screen recording, webcam capture, and text overlays. It provides a timeline-based editing interface that allows users to combine multiple media sources into a single promotional video, making it the ideal tool for this task.

Answer

Microsoft Stream

Answer

Microsoft PowerPoint

Answer

Microsoft Sway

Question 12

A team wants to build a custom business app to track inventory with minimal custom code. They need a cloud-based database that can store structured data and is tightly integrated with the low-code app platform. Which Microsoft 365 service should they use as the database?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse (formerly Common Data Service) is the cloud-scale database that stores data used by Power Apps, Power Automate, and Dynamics 365. It provides a relational data store with built-in security, business logic, and integration. Power Apps can connect directly to Dataverse to create custom apps with minimal code. SharePoint lists or Excel Online are less suitable for scalable business apps requiring relationships and business rules.

Answer

Microsoft SharePoint Online list

Answer

Microsoft Excel Online

Answer

Microsoft Forms

Question 13

A marketing team needs to create a printed newsletter that includes custom graphics, text boxes, and precise layout control. Which Microsoft 365 app is specifically designed for desktop publishing tasks like this?

Accepted Answer

Microsoft Publisher. Microsoft Publisher is the correct answer because it is specifically designed for desktop publishing (DTP) tasks such as creating printed newsletters with custom graphics, text boxes, and precise layout control. Unlike general-purpose word processors or presentation tools, Publisher provides advanced page layout features, including master pages, typography controls, and fine-grained object positioning, making it the appropriate choice for this scenario.

Answer

Microsoft Word

Answer

Microsoft Sway

Answer

Microsoft PowerPoint

Question 14

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?

Accepted Answer

Microsoft Lists. Microsoft Lists is designed for creating and sharing flexible lists with custom columns, real-time collaboration, and version history. Excel can be shared but is not as purpose-built for list management. SharePoint can host lists, but Microsoft Lists is the dedicated app. Teams can display a list as a tab, but the underlying app is Lists.

Answer

Microsoft Excel

Answer

Microsoft SharePoint

Answer

Microsoft Teams

Question 15

A graphic designer needs to create a professional printed brochure with custom page layouts, text wrapping around images, and precise control over typography. Which Microsoft 365 app is designed for this type of desktop publishing task?

Accepted Answer

Microsoft Publisher. Microsoft Publisher is the correct choice because it is specifically designed for desktop publishing tasks such as creating professional brochures with custom page layouts, text wrapping around images, and precise typography control. Unlike general-purpose apps, Publisher offers advanced layout tools like master pages, baseline guides, and typographic controls that are essential for print-ready documents.

Answer

Microsoft Sway

Answer

Microsoft Word

Answer

Microsoft PowerPoint