FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A custom list can correspond to a cell range, or you can enter the list in the Custom Lists dialog box. Note: A custom list can only contain text or text that is mixed with numbers. For a custom list that contains numbers only, such as 0 through 100, you must first create a list of numbers that is formatted as text.

Detailed explanation-2: -Custom Sorting With key= For more complex custom sorting, sorted() takes an optional “key=” specifying a “key” function that transforms each element before comparison. The key function takes in 1 value and returns 1 value, and the returned “proxy” value is used for the comparisons within the sort.

Detailed explanation-3: -Select any cell within the range you want to sort. On the Data tab, in the Sort & Filter group, select Custom Sort. In the Custom Sort dialog box, click Options. Under Row, in the ‘Sort by’ drop down, select the row that you want to sort.