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?
Answer
A
Use the Cut and Paste option to reorganize the data to fit that order.
B
Use the Filter function to organize the data based on the date.
C
Use the Order function to organize the data based on the date.
D
Use the Sort function to organize the data based on date order.
Explanation
To rearrange worksheet rows according to values in the Date column, Keisha should use the Sort function and select Date as the sorting field. Sorting orders the records by date while keeping each row’s related information together. Filtering only displays selected records, and cut and paste would require manual rearranging.
AI-written and checked against the verified answer.