Which external reference is formatted correctly? (My_Sales)!quarter1:C12 “My_Sales”[quarter1]!C12 ‘[My_Sales]quarter1’!C12 !My_Sales!quarter1”C12”

Kiesha has a worksheet with a range of cells using the following columns: name, score, group, study group, and date. kiesha needs to sort the worksheet on the date field. which option 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