Which statement best explains why the Find Unmatched Query Wizard must be used with an outer join and not an inner join? A. An outer join is the default type of join and cannot be changed for this type of query. B. An inner join eliminates all unmatched records by design, so it cannot identify records for this type of query.
C. Inner joins use data from only one table, and the Find Unmatched Query Wizard needs data from two tables.
D. Outer joins are the only type of joins that have the Query Wizard options in the Create tab of the Ribbon.

What should the sales manager do in order to present the owner with a PivotTable in which the owner can most easily filter certain vehicle options in or out to see buyer demands for those options?

A.The sales manager should create slicers for each option that should be filtered and let the owner click within those slicers.

B.The sales manager should create a collection of PivotTables that each use different vehicle options in the Report Filter section.

C.The sales manager should place every vehicle option in the Report Filter section and show the owner how to open the different filters.

D.The sales manager should place a vehicle option in the Row Labels section instead of the vehicle model and let the owner try different options as the row labels.