DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The Name Manager, where named cell ranges can be edited, is on which tab?
|
|
Formulas
|
|
|
Home
|
|
|
Page Layout
|
|
|
Data
|
Explanation:
Detailed explanation-1: -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-2: -You can find a named range by using the Go To feature-which navigates to any named range throughout the entire workbook. You can find a named range by going to the Home tab, clicking Find & Select, and then Go To. Or, press Ctrl+G on your keyboard.
Detailed explanation-3: -To manage range names, go to the Formulas tab, select Name Manager, choose a name, then select Delete or Edit.
There is 1 question to complete.