DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
It is very handy to fill a range of cells with your own list which you have already created.
|
|
Auto Fill
|
|
|
Custom List
|
|
|
Auto List
|
|
|
Fill Handle
|
Explanation:
Detailed explanation-1: -Select the range containing the list. Go to the File menu and select Options. In the Excel Options dialog, choose Advanced from the left navigation bar. In the Advanced Excel Options, scroll 83% of the way through the list and select the button for Edit Custom Lists.
Detailed explanation-2: -Custom lists in Excel are used to sort data based on the user’s choice. It is especially useful when you need to perform multiple tasks on the same data on a repetitive basis.
There is 1 question to complete.