USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following correctly identifies the different parts of the following reference:Tours!B4
|
|
Tours is the name of the worksheet and B4 is the cell reference.
|
|
|
Tours is the name of the workbook file and B4 is the cell reference.
|
|
|
Tours is a named range in the worksheet, and B4 is the cell reference.
|
|
|
Tours is the name of the column and B4 is the name of the row.
|
Explanation:
Detailed explanation-1: -On the Formulas tab, in the Defined Names group, click Define Name. In the New Name dialog box, in the Name box, type the name you want to use for your reference. Note: 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: -To do this, you’ll simply need to begin the cell reference with the worksheet name followed by an exclamation point (!). For example, if you wanted to reference cell A1 on Sheet1, its cell reference would be Sheet1!A1.
There is 1 question to complete.