USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Group Locator
|
|
|
Name Manager
|
|
|
Content Finder
|
|
|
Table Index
|
Detailed explanation-1: -The Go to box keeps track of ranges as you enter them, and you can return to any of them by double-clicking. To go to a cell or range on another sheet, enter the following in the Reference box: the sheet name together with an exclamation point and absolute cell references.
Detailed explanation-2: -Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope.
Detailed explanation-3: -Note that the cell address also appears in the Name box in the top-left corner, and that a cell’s column and row headings are highlighted when the cell is selected. If the columns in your spreadsheet are labeled with numbers instead of letters, you’ll need to change the default reference style for Excel.
Detailed explanation-4: -You can move cells in Excel by drag and dropping or using the Cut and Paste commands. Select the cells or range of cells that you want to move or copy. Point to the border of the selection., drag the cell or range of cells to another location.