DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The ____ command enables you to debug a formula by stepping through each part of a formula individually.
|
|
Formula Options
|
|
|
Evaluate Formula
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -In Microsoft Excel, F9 key is an easy and quick way to check and debug formulas.
Detailed explanation-2: -The F9 key is used to quickly evaluate and debug the formula to understand and efficiently work with Excel. Using this F9 key, we can determine only the part of the formula by replacing the actual formula with the result of the formula.
Detailed explanation-3: -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.
There is 1 question to complete.