Question

1. a data analyst reviews a spreadsheet of boat auction sales to find the last five sailboats sold in kentucky. what steps would they take in order to narrow the scope? select all that apply. □ sort by date in descending order □ filter out sales in kentucky □ filter out sales outside of kentucky □ sort by date in ascending order

Explanation:

To narrow the scope to the last five sailboats sold in Kentucky, first, we need to isolate only the sales that occurred in Kentucky. This can be done either by filtering to keep only Kentucky sales or filtering out sales from outside Kentucky. Then, we sort the remaining Kentucky sales in descending date order to place the most recent (last) sales at the top, making it easy to retrieve the first five entries. Sorting in ascending order would put the oldest sales first, which does not help find the last five.

Answer:

• Sort by date in descending order
• Filter out sales in Kentucky
• Filter out sales outside of Kentucky