DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A cell name often is created from column and row titles. You cannot use column and row titles within formulas when you want to refer to the related data by name. Assigning names to a cell or range of cells allows you to select them quickly. Spreadsheet specialists usually format a worksheet before they enter any data.
Detailed explanation-2: -Assigning names to cells or ranges of cells allows us to quickly select the cells. A named range is also easier to remember and to use in formulas. Excel provides three methods to name a cell or a range of cells: Name Box.
Detailed explanation-3: -The Name Box in Excel is fastest way to create a named range: Select a cell or a range of cells that you want to name. Type a name into the Name Box. Press the Enter key.