USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Group that allows a user to create names for cells to use in a formula
|
|
Name Box
|
|
|
Defined Names
|
|
|
Dialog Box
|
|
|
Name Manager
|
Explanation:
Detailed explanation-1: -Go to the Formulas tab > Define Names group, and click the Create from Selection button. Or, press the keyboard shortcut Ctrl + Shift + F3. Either way, the Create Names from Selection dialogue box will open. You select the column or row with headers, or both, and click OK.
There is 1 question to complete.