USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
(FORMULAS tab | Function Library group)
|
|
|
(FORMULAS tab | Defined Names group)
|
|
|
(FORMULAS tab | Names group)
|
|
|
(FORMULAS tab | Calculation group)
|
Detailed explanation-1: -First, we must go to the “Formulas” tab > “Defined Names” group, then click the “Name Manager.” Alternatively, we can press “Ctrl + F3” (the shortcut for Name Manager). For a new named range, click on the “New” button. You may see the window below by clicking the “New” button.
Detailed explanation-2: -On the Formulas tab, in the Defined Names group, click Name Manager. In the Name Manager dialog box, double-click the name you want to edit, or, click the name that you want to change, and then click Edit.
Detailed explanation-3: -Manage names in your workbook with Name Manager On the Ribbon, go to Formulas > Defined Names > Name Manager. You can then create, edit, delete, and find all the names used in the workbook.
Detailed explanation-4: -Click the Home tab; Go to Font group; Then you will view the border button, as the figure 2 shows above.
Detailed explanation-5: -Apply a custom view Go to View > Workbook Views > Custom Views.