USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Function Library
|
|
Defined Names
|
|
Formula Auditing
|
|
Calculation
|
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.
Detailed explanation-2: -On the Formulas tab, in the Defined Names group, click Create from Selection. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
Detailed explanation-3: -Show Formulas option on the Excel ribbon In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.