USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Entry
|
|
|
Workbook
|
|
|
Row
|
|
|
Column
|
Detailed explanation-1: -Define a name for a cell or cell range on a worksheet Select the cell, range of cells, or nonadjacent selections that you want to name. Click the Name box at the left end of the formula bar. Type the name you want to use to refer to your selection. Names can be up to 255 characters in length.
Detailed explanation-2: -Absolute. a cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied and is indicated by the $ sign.
Detailed explanation-3: -Select View > View Side by Side. If you scroll up or down, the other scrolls as well. If you want them to scroll separately, select Synchronous Scrolling to turn it off.
Detailed explanation-4: -Cells are the boxes you see in the grid of an Excel worksheet, like this one. Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.