You have a Microsoft 365 subscription that uses Microsoft Purview and contains a Microsoft SharePoint...

This question refers to Microsoft Purview Content Search queries, which use KQL (Keyword Query Language) for searching files and metadata in SharePoint, Exchange, and other M365 repositories.

Search1: Author: " User1 " FileExtension:xlsx

This query searches for items authored by User1 and with file extension .xlsx .

In the dataset, only File3.xlsx has the .xlsx extension, but its Author is User3 , not User1.

Therefore, S earch1 will not return File3 → Answer: No . (Correction after logical review)

Search2: Author: " User* " and FileExtension:*

The wildcard User* matches any author name starting with “User” (User1, User2, User3).

FileExtension:* matches any file type that has a n extension.

Therefore, all three files (File1.docx, File2.docx, File3.xlsx) match this query.

Hence, Search2 will return File1 → Answer: Yes .

Search3: Author:(User1..3)

The range (User1..3) is interpreted as a range query that matches Author values between User1 and User3 .

This includes User1, User2, and User3 , depending on how metadata strings are indexed.

Therefore, File2 (authored by User2) is included in this range.

Hence, Search3 will return File2 → Answer: Yes .

✅ Final Correct Table

Statement

Yes

No

Search1 will return File3

✔ ️

Search2 will return File1

✔ ️

Search3 will return File2

✔ ️

Summary:

Search1: No (author and extension don’t match).

Search2: Yes (wildcard matches all “User” authors).

Search3: Yes (range includes User2).

These results align with Microsoft Purview content search KQL syntax and behavior documented in Microsoft 365 eDiscovery (Standard) and Purview content search guidance.