Skip to main content
  1. Public practice questions
  2. AB-900 Practice Exams | Copilot and Agent Administration Fundamentals
  3. AB-900 Practice Exam 3

Question 26 — AB-900 Practice Exam 3

A department head wants to identify trends, anomalies, and forecasts from several years of budget spreadsheets without using pivot tables or formulas. Which tool is the best fit? (Select one answer)

  1. Researcher agent

  2. Analyst agent

  3. Copilot Chat

  4. Writing Coach

Correct answers

  1. Analyst agent

Explanations

Correct:
Analyst agent
The Analyst agent works with structured data and can generate insights, forecasts, and visualizations.

Wrong:
Researcher agent
Researcher is optimized for unstructured information.
Copilot Chat
Copilot Chat is not optimized for deep spreadsheet analysis.
Writing Coach
Writing Coach focuses on written communication quality.