3.5 Test your knowledge on sorting and filtering

What is the process for arranging data into a meaningful order to make it easier to understand, analyze, and visualize?

A. Prioritizing

B. Filtering

C. Reframing

D. Sorting

D. Sorting

A data analyst is reviewing a national database of real estate sales. They are only interested in sales of condominiums. How can the analyst narrow their scope?

A. Filter out non-condominium sales

B. Sort by non-condominium sales

C. Filter out condominium sales

D. Sort by condominium sales

A. Filter out non-condominium sales

A data analyst works for a rental car company. They have a spreadsheet that lists car ID numbers and the dates cars were returned. How should they sort the spreadsheet to find the most recently returned cars?

A. By car numerical ID, in descending order

B. By return date, in descending order

C. By return date, in ascending order

D. By car numerical ID, in ascending order

B. By return date, in descending order

Fill in the blank: To keep a header row at the top of a spreadsheet, highlight the row and select ___ from the View menu.

A. lock

B. set

C. freeze

D. pin

C. Freeze