A sales team at Contoso spends hours each week drafting personalized proposal documents in Word and pulling the latest quarterly numbers from an Excel workbook. The team wants to reduce the time spent on repetitive formatting and data lookup so they can focus on client interactions. Which Microsoft 365 feature should the team use to draft a proposal draft that incorporates the latest figures from the Excel workbook with minimal manual effort?

Microsoft Forms to create a survey that collects the latest figures from the sales team

Microsoft To Do to assign proposal-writing tasks to team members

Microsoft Lists to track the proposal status and manually copy figures into the document

Microsoft 365 Copilot in Word, referencing the Excel workbook as a data source

What is the primary purpose of Microsoft Lists?

To create and manage lists of information for tracking and organizing data

To manage project schedules with Gantt charts

To create and deliver presentations

Which of the following tasks can Microsoft 365 Copilot Chat perform to facilitate collaboration?

Managing user permissions in SharePoint

Creating a new Microsoft Teams team

Summarizing a chain of emails or a meeting transcript

Sending automated emails to all employees

Microsoft Certified:Microsoft 365 Fundamentals

Domain 2Objective 1

Describe Productivity Solutions of Microsoft 365 MS-900 Practice Questions (Page 2)

Part of the Describe Microsoft 365 apps and services domain, which accounts for 45–50% of the MS-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~9–15 in this domain), expect 2–4 from this objective — we provide 46 practice questions to prepare you well beyond it. (estimate)

46questions here

10free pages

13concepts

45–50%of the exam

13 Concepts in This Objective

Microsoft Word Capabilities
Microsoft Excel Capabilities
Microsoft PowerPoint Capabilities
Microsoft OneNote Capabilities
Microsoft 365 Copilot Benefits
Microsoft 365 Copilot Chat
Microsoft Project Management Tools
Microsoft Planner Features
Microsoft Bookings Capabilities
Microsoft Forms Features
Microsoft Lists Capabilities
Microsoft To Do Features
Microsoft Loop Features

Questions 6–10

6application · medium
A sales team at Contoso spends hours each week drafting personalized proposal documents in Word and pulling the latest quarterly numbers from an Excel workbook. The team wants to reduce the time spent on repetitive formatting and data lookup so they can focus on client interactions. Which Microsoft 365 feature should the team use to draft a proposal draft that incorporates the latest figures from the Excel workbook with minimal manual effort?
Select an answer first
7foundation · easy
What is the primary purpose of Microsoft Lists?
Select an answer first
8foundation · easy
A sales manager wants to create a summary report that shows total sales by region and by product category without writing formulas. Which Excel feature is specifically designed for this type of interactive data summarization?
Select an answer first
9foundation · easy
Which of the following tasks can Microsoft 365 Copilot Chat perform to facilitate collaboration?
Select an answer first
10foundation · easy
Which PowerPoint feature provides a collection of pre-designed slide layouts that include placeholders for titles, text, and graphics, helping users maintain consistent formatting across slides?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to MS-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “MS-900” is a trademark of its owner, used for identification only.

Describe Productivity Solutions of Microsoft 365 MS-900 Practice Questions (Page 2)

Questions 6–10

What is the primary purpose of Microsoft Lists?

A sales manager wants to create a summary report that shows total sales by region and by product category without writing formulas. Which Excel feature is specifically designed for this type of interactive data summarization?

Which of the following tasks can Microsoft 365 Copilot Chat perform to facilitate collaboration?

Which PowerPoint feature provides a collection of pre-designed slide layouts that include placeholders for titles, text, and graphics, helping users maintain consistent formatting across slides?

Keep studying — Describe Microsoft 365 apps and services