USING MICROSOFT EXCEL
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: -Alt+F8 displays the Macro dialog box to create, run, edit, or delete a macro. F9 Calculates all worksheets in all open workbooks. Shift+F9 calculates the active worksheet. Ctrl+Alt+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.