DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
[CTRL][+]
|
|
|
[CTRL][‘]
|
|
|
[CTRL][F]
|
|
|
[CTRL][*]
|
Detailed explanation-1: -Click on Formulas and then click on Show Formulas to switch between displaying formulas and results.
Detailed explanation-2: -If you want to see the formulas for a specific cell, you can use the shortcut Ctrl + F3. This shortcut will open the Formula Auditing pane, which will show you all the formulas that affect the selected cell. If you want to see the formulas for a range of cells, you can use the shortcut Ctrl + Shift + F3.
Detailed explanation-3: -With a quick key combination you can see formulas instead of formula results in a worksheet. To show formulas in all cells press CTRL+‘ (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would.
Detailed explanation-4: -The quickest way to evaluate a formula in Excel is to press CTRL + (tilde). This toggles the display of the current worksheet, allowing you to switch views between cell values and cell formulas.