USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To show all formulas in a workbook go to:
|
|
Formulas tab-> Insert Function
|
|
|
Formulas tab-> Name Manager
|
|
|
Formulas tab-> Define Name
|
|
|
Formulas tab-> Show Formulas
|
Explanation:
Detailed explanation-1: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).
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.
There is 1 question to complete.