FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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?
A
Formulas
B
Home
C
Page Layout
D
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: -Alternatively, highlight the desired range, select the Formulas tab on the ribbon, then select Define Name. 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.