USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To display formulas in cells rather than formula results, use:
|
|
The Show Formulas command
|
|
|
Print Preview
|
|
|
Print Titles
|
|
|
The Escape (Esc) key
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
Detailed explanation-3: -Select the cell with the formula, press F2, and then press ENTER. The cell displays the value.
There is 1 question to complete.