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, Search1 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 an 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.