You are interested in quickly filtering the data in the Loans, Officers, and Members query based on loan officer. Filtering by selection allows you to select your filtering criteria and apply it to the data. In this case, you would like to see only the loans managed by John Badman. Use filter by selection to show only the loans managed by the loan officer whose name is John Badman. Hint: In the LoanOfficer column, select the cell containing John Badman. On the Home tab, in the Sort & Filter group, click Selection