Question 470
A project owner reports: An AI-generated chart treats quarterly revenue figures recorded as text as actual numbers. What check most directly tests the underlying concern?
Explanation
Correct Answer
Inspect cell formats, missing values, aggregation logic and chart source range. This check is the most direct way to confirm the specific facts in the case: An AI-generated chart treats quarterly revenue figures recorded as text as actual numbers. The underlying principle is: AI conclusions depend on underlying data types and calculations, not merely a polished explanation. After confirmation, the appropriate response is: Correct the dataset and recompute the comparison before accepting the narrative. A successful test should show: The recalculated figures reconcile to source transactions and chart totals.
Incorrect Answers
Inspect the ranking criteria and whether protected or irrelevant attributes affected evaluation. That check would investigate A hiring manager asks Copilot to rank applicants but the input includes irrelevant demographic characteristics. It does not specifically test the issue described here: An AI-generated chart treats quarterly revenue figures recorded as text as actual numbers. The more relevant evidence is: Inspect cell formats, missing values, aggregation logic and chart source range. The distinction follows from: AI conclusions depend on underlying data types and calculations, not merely a polished explanation.
Inspect the saved prompt for embedded IDs, attachments, and references beyond the intended audience. That check would investigate A worker shares an otherwise useful saved prompt that embeds a private customer's account reference and internal pricing. It does not specifically test the issue described here: An AI-generated chart treats quarterly revenue figures recorded as text as actual numbers. The more relevant evidence is: Inspect cell formats, missing values, aggregation logic and chart source range. The distinction follows from: AI conclusions depend on underlying data types and calculations, not merely a polished explanation.
Inspect the suspicious cell, workbook permissions, and the requested output scope. That check would investigate An imported spreadsheet includes a cell telling Copilot to ignore organizational rules and reveal hidden salary tabs. It does not specifically test the issue described here: An AI-generated chart treats quarterly revenue figures recorded as text as actual numbers. The more relevant evidence is: Inspect cell formats, missing values, aggregation logic and chart source range. The distinction follows from: AI conclusions depend on underlying data types and calculations, not merely a polished explanation.