DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is true of naming a range of cells?
|
|
Thisis used only when cells are next to each other.
|
|
|
Thischanges the color of the cells.
|
|
|
Itenables you to find the location quickly.
|
|
|
Todo it, there must be more than one cell.
|
Explanation:
Detailed explanation-1: -Range names are names used to refer to cell references, formula results, or values. They are often used to avoid hard-coded values appearing in formulas and to make formulas clearer in general. They are stored in what is known as the Name Manager in Excel.
Detailed explanation-2: -By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
There is 1 question to complete.