Salesforce Certified Advanced Administrator Exam - Excel Connector and SFDC Reports Filter Criteria Differences

How the Excel Connector and SFDC Reports Differ in Filter Criteria Support

Question

SIMULATION - How do the Excel connector and SFDC reports differ in their support for filter criteria?

Explanations

See the solution below.

Excel Connector: Query is one object per query, using the API.

Reports: offer multiple objects, and/or criteria.

Sure, I'd be happy to explain the difference between the Excel connector and SFDC reports in terms of their support for filter criteria.

Excel Connector: The Excel connector is a tool that allows users to import data from Salesforce into Excel and vice versa. When using the Excel connector to filter data, users can only apply filters to the data that has