AB-730, AI, Generative AI, Microsoft Certification

Move data and insights between Microsoft 365 apps (AB-730 Exam Prep)

 
This post is a part of the AB-730: AI Business Professional Exam Prep Hub.
This topic falls under these sections:
Draft and analyze business content by using AI (25–30%)
   --> Draft business documents and communications
      --> Move data and insights between Microsoft 365 apps

Note that there are 10 practice questions (with answers) at the end of each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available from the hub's main page below the exam topics section.

Introduction

One of the major strengths of Microsoft 365 Copilot is that it works across multiple Microsoft 365 applications rather than operating in isolation. Business users frequently create information in one app and then need to reuse, summarize, analyze, or present that information in another app.

For example:

  • Notes from a Teams meeting may become a Word document.
  • Excel analysis may become a PowerPoint presentation.
  • Email discussions may become action items in Teams.
  • A Word report may be summarized into an executive email in Outlook.

Understanding how to move information and insights between Microsoft 365 apps is an important skill measured on the AB-730 exam.

Why Cross-App Workflows Matter

Business processes rarely occur in a single application.

A typical workflow might involve:

  1. Collaborating in Teams.
  2. Storing files in SharePoint or OneDrive.
  3. Analyzing information in Excel.
  4. Writing reports in Word.
  5. Presenting results in PowerPoint.
  6. Communicating outcomes through Outlook.

Microsoft 365 Copilot helps connect these experiences by using the Microsoft Graph and organizational data permissions to surface relevant information.

Benefits include:

  • Reduced manual copying and pasting.
  • Faster content creation.
  • Improved consistency.
  • Better collaboration.
  • Less duplication of work.

Common Cross-App Scenarios

Teams → Word

After a meeting, Copilot can:

  • Summarize the meeting discussion.
  • Identify decisions and action items.
  • Help create a project report in Word.

Example:

A project manager uses meeting notes from Teams to generate a weekly status report in Word.

Word → PowerPoint

Copilot can use an existing document to:

  • Create presentation slides.
  • Extract key points.
  • Organize information into sections.

Example:

A 20-page proposal in Word becomes a 10-slide executive presentation.

Excel → PowerPoint

Insights generated in Excel can be used to:

  • Explain trends.
  • Highlight KPIs.
  • Present charts and findings.

Example:

Quarterly sales analysis from Excel becomes a leadership presentation in PowerPoint.

Outlook → Word

Email conversations can provide context for:

  • Drafting reports.
  • Creating summaries.
  • Building proposals.

Example:

Several customer emails are summarized into a requirements document.

Word → Outlook

Copilot can turn a lengthy report into:

  • A concise email.
  • An executive summary.
  • A stakeholder update.

Example:

A project report becomes an email sent to department leaders.

Teams → Planner or Task Lists

Meeting action items identified by Copilot can be used to:

  • Assign tasks.
  • Track deliverables.
  • Improve accountability.

Using References Across Apps

Microsoft 365 Copilot allows users to reference existing files when creating new content.

Examples:

In Word

“Create a proposal based on the Q2 Financial Analysis.xlsx workbook.”

In PowerPoint

“Build a presentation using the Product Launch Plan.docx document.”

In Outlook

“Draft an email summarizing the attached report.”

In Copilot Chat

“Summarize yesterday’s Teams meeting and prepare follow-up actions.”

Providing references improves:

  • Accuracy.
  • Context.
  • Relevance.
  • Consistency.

How Copilot Preserves Context

Copilot can connect information from:

  • Word documents.
  • Excel workbooks.
  • PowerPoint presentations.
  • Teams meetings.
  • Outlook emails.
  • OneDrive files.
  • SharePoint documents.

Because permissions are respected, users only receive information they are already authorized to access.

Best Practices for Moving Information Between Apps

1. Start with Existing Content

Rather than creating content from scratch, reference:

  • Documents.
  • Presentations.
  • Spreadsheets.
  • Emails.
  • Meeting notes.

This gives Copilot more context.

2. Verify Generated Results

Always review:

  • Facts.
  • Numbers.
  • Names.
  • Dates.
  • Recommendations.

Human review remains essential.

3. Use Specific Prompts

Instead of:

Create a presentation.

Use:

Create a five-slide presentation from the Q3 Sales Report and emphasize regional growth trends.

Specific prompts produce better outputs.

4. Maintain Security

Only reference files that:

  • Are appropriate to share.
  • Contain approved information.
  • Follow organizational policies.

5. Refine the Output

Generated content often benefits from:

  • Editing.
  • Formatting.
  • Adding visuals.
  • Clarifying language.

Copilot accelerates work but does not eliminate the need for review.

Example End-to-End Workflow

Step 1

Conduct a meeting in Teams.

Step 2

Use Copilot to summarize the discussion.

Step 3

Create a Word report from the meeting summary.

Step 4

Analyze supporting data in Excel.

Step 5

Generate a PowerPoint presentation from the report.

Step 6

Draft an Outlook email to stakeholders summarizing the outcome.

This illustrates how information flows across Microsoft 365 experiences.

Key Exam Points

For the AB-730 exam, remember:

  • Microsoft 365 Copilot works across apps.
  • Existing files can serve as references for new content.
  • Teams, Word, Excel, PowerPoint, and Outlook frequently work together.
  • Copilot helps move insights rather than requiring users to recreate information.
  • Permissions and security boundaries are maintained.
  • Human review is still required.

Practice Exam Questions

Question 1

A manager wants to turn a completed Word report into a slide deck for executives. Which Microsoft 365 app is most appropriate for presenting the information?

A. Excel
B. Teams
C. PowerPoint
D. Outlook

Answer: C

Explanation: PowerPoint is designed for presentations. Copilot can generate slides based on an existing Word document.

Question 2

Which benefit is gained by referencing an existing document when creating new content?

A. Copilot ignores organizational permissions.
B. Copilot receives additional context and can create more relevant output.
C. The file becomes publicly accessible.
D. Human review is no longer necessary.

Answer: B

Explanation: Existing documents provide context that helps Copilot generate more accurate and useful responses.

Question 3

A user wants to summarize meeting discussions and convert them into a report. Which application most likely contains the original conversation?

A. Teams
B. Excel
C. PowerPoint
D. Access

Answer: A

Explanation: Teams meetings often contain conversations and transcripts that Copilot can summarize.

Question 4

What should users do after moving insights between Microsoft 365 applications?

A. Publish immediately without review.
B. Disable security permissions.
C. Ignore formatting.
D. Verify the generated output.

Answer: D

Explanation: Human review helps ensure correctness and quality.

Question 5

Which scenario best demonstrates a cross-app workflow?

A. Using Word to change fonts.
B. Opening the same file twice.
C. Creating PowerPoint slides from a Word document.
D. Restarting Microsoft 365.

Answer: C

Explanation: This involves using information from one app to create content in another.

Question 6

Which Microsoft 365 app is primarily used for analyzing numerical data and trends?

A. Excel
B. Outlook
C. Teams
D. OneNote

Answer: A

Explanation: Excel specializes in calculations, charts, and data analysis.

Question 7

Why can Copilot safely surface information across Microsoft 365 applications?

A. It removes all access restrictions.
B. It shares every document with everyone.
C. It bypasses organizational security settings.
D. It respects existing permissions.

Answer: D

Explanation: Copilot only accesses information users are already authorized to view.

Question 8

Which prompt provides the BEST context?

A. Create something.
B. Help me.
C. Build a five-slide presentation from the Q3 Sales Report emphasizing customer growth.
D. Use random information.

Answer: C

Explanation: Specific instructions and referenced content improve output quality.

Question 9

A user wants to send stakeholders a short update based on a lengthy report. Which app is most appropriate for delivering the message?

A. Outlook
B. Excel
C. Access
D. Visio

Answer: A

Explanation: Outlook is commonly used for communicating summaries and updates.

Question 10

Which statement about Microsoft 365 Copilot is TRUE?

A. Content must always be recreated manually in each app.
B. Information cannot move between applications.
C. Cross-app workflows help reduce duplicated effort.
D. Copilot only works inside Word.

Answer: C

Explanation: One of Copilot’s strengths is enabling information and insights to flow across Microsoft 365 applications, improving efficiency and reducing repetitive work.

Go to the AB-730 Exam Prep Hub main page

Leave a comment