USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
reveal formulas
|
|
show formulas
|
|
unhide formulas
|
|
show cells
|
Detailed explanation-1: -On your keyboard, typing the shortcut command Ctrl+‘, will toggle on (or show) the formulas.
Detailed explanation-2: -To show the Formula Bar, click the View tab, and then click to select the Formula Bar check box. Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U.
Detailed explanation-3: -Showing formulas using a keyboard shortcut Press Ctrl + tilde ( ) or Ctrl + accent grave (‘) to show or hide formulas. The tilde / accent grave key appears on the top left of most keyboards below the Esc key. This shortcut works in all versions of Excel.
Detailed explanation-4: -The FORMULATEXT function returns what is displayed in the formula bar if you select the referenced cell. The Reference argument can be to another worksheet or workbook.
Detailed explanation-5: -Correct common formula errors one by one Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.