FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
To see what math formulas are used in a cell, click on the
A
Show formulas button
B
Show the math button
C
the auto sum button
D
None of the above
Explanation: 

Detailed explanation-1: -On your keyboard, typing the shortcut command Ctrl+‘, will toggle on (or show) the formulas. (Note that the ‘ in this shortcut is the grave accent mark, usually located to the left of the 1 key on your keyboard.) Typing the shortcut command Ctrl+‘ again will toggle off the formulas.

Detailed explanation-2: -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-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.

There is 1 question to complete.
Previous
Next