When creating an index one can determine if an index column is sorted using ascending or descending order. BOL says that
[ ASC | DESC ] Determines the ascending or descending sort direction for the particular index column. The default is ASC.
What is the primary reason for choosing between