A data analyst needs to organize sales data for analysis. Which Excel function can order the data by date sold, with the most recent sales listed first?
- Sort & Filter
- Conditional Formatting
- Text to Columns
- Find & Select
| Explanation & Hint:
The Sort & Filter tool in Excel allows an analyst to sort the contents of a column in either ascending order so that dates are earliest to most recent or descending order so that dates are most recent to earliest. |