Question 152 of 217
MS-900 Describe Microsoft 365 apps and services Practice Question
A sales representative needs to quickly create a professional-looking price quote that includes dynamic pricing from a company database and send it as a PDF to a customer. Which Microsoft 365 app is best suited for this?
⚠ Common exam trap
Many candidates confuse Excel's data calculation capabilities with document creation, assuming a spreadsheet can produce a professional quote, but Word is the correct app for formatted, PDF-ready documents with dynamic content.
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 Word
Microsoft Word is best suited because it supports mail merge and dynamic content from external data sources like a company database. Using Word's 'Insert Quick Parts' or mail merge features, a sales rep can pull live pricing data into a professional quote template and then export the document as a PDF directly from Word.
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 Word
Why this is correct
Word is a full-featured word processor that supports precise page layout, rich typography, tables, headers/footers, and embedded objects, all essential for a polished, branded sales quote. It can pull live data from Excel or external databases via linked content and mail merge fields, then export to a fixed-layout PDF via Save As, guaranteeing the recipient sees an identical professional document.
- ✗
Microsoft Excel
Why it's wrong here
Excel is a spreadsheet application optimized for numerical analysis, formulas, and data modeling, making it excellent for calculating pricing or discounts behind the scenes. As a quote deliverable, its grid-based interface fights against professional narrative formatting; wrapped text, merged cells, and discontinuous print areas are awkward to manage, and the result often looks like a data table rather than a formal client-facing document.
- ✗
Microsoft Sway
Why it's wrong here
Sway is a digital storytelling tool that generates responsive, web-based presentations and newsletters from media cards, with no concept of fixed pages or print-oriented layout. Output is an HTML canvas that reflows across devices, so a consistent paginated PDF with controlled margins and fonts cannot be reliably produced, which disqualifies it for formal quotes.
- ✗
Microsoft SharePoint Online
Why it's wrong here
SharePoint Online is a collaboration and content-management platform that stores documents, manages versions, and enforces permissions, but it does not itself render or format business deliverables. To create a quote you would need a client app such as Word Desktop or Word Online and then upload the finished file to a SharePoint document library for sharing and co-authoring; SharePoint alone cannot author the quote.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 11, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.