Question

different between sorting and filtering?only 2 point

Answer 1

1. When I use Sort to sort data in Excel, it sorts the entire table – which makes sense but might not be the best way forward.
2. Autofilter gives me the option to view the bits of data I actually want, and filter out the ones I don’t.