Sorting is the process of arranging the data in alphabetical or numeric order either in ascending order or descending order.
1. Absolute Cell Reference
Ex: $A$5
2. Relative Cell Reference
Ex: A5
3. Mixed Cell Reference
Ex: $A5 or A$5