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?

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.

Question

Computers & Technology

Abigayle Cortez

22 July, 14:45

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?

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.

+5

Answers (2)

Know the Answer?

Karina Cannon · Answer 1

A is the answer

Nobel · Answer 2

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

Explanation:

Excel allows you to organize data in different forms, for example, in alphabetical order, from the smallest to the highest number, among others. This can be done by using the sort function. If Keisha wants to sort the worksheet on the Date field, she has to select a cell in the date column and click on sort and filter and then choose sort from A to Z (from an earlier to a later date) or sort from Z to A (from a later to an earlier date).