Question

Keisha has a worksheet with a range of cells using the following columns: Name, Score, Group, Study Group, and Date. Keisha needs to sort the worksheet on the Date field. Which option should she use to most efficiently complete this task?

Use the Cut and Paste option to reorganize the data to fit that order.
Use the Filter function to organize the data based on the date.
Use the Order function to organize the data based on the date.
Use the Sort function to organize the data based on date order.

Answer 1

Use the Sort function to organize the data based on date order.

(select the Date column or the whole table, then use Data → Sort and choose the Date field and ascending/descending; make sure "My data has headers" is checked)