DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
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: -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-4: -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.
Detailed explanation-5: -The shortcut to show the formula in Excel is “Ctrl + ‘.” The key (’) is on the keyboard below the “Esc” button.