USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -To create a named range, simply select a cell or cell range, then type the desired name into the Name box (to the left of the formula bar). You can then use the new name whenever you want to refer to that cell range.
Detailed explanation-2: -Change a Named Range On the Ribbon, click the Formulas tab. Click Name Manager. In the list, click on the name that you want to change. In the Refers To box, change the range reference, or drag on the worksheet, to select the new range.
There is 1 question to complete.