USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell address
|
|
|
Constant
|
|
|
Function
|
|
|
None of these
|
Detailed explanation-1: -The correct answer is “Constant". Key Points. A formula that does not change its value in excel is called constant: A constant is a fixed value that does not change, and is introduced directly into a cell.
Detailed explanation-2: -In MS-Excel, the value used in a formula that does not change is called a . Answer : Constant.
Detailed explanation-3: -A constant is a set value that doesn’t change and that’s directly inserted into a cell. It’s not a formula and it’s not calculated by a formula.
Detailed explanation-4: -Absolute Cell Reference(Keeping value constant in an excel formula) When you want certain cell reference to remain unchanged or want to keep a value constant, that is the time you will have to use absolute cell reference.
Detailed explanation-5: -Absolute Cell Reference: An absolute cell reference is one that does not change when it is copied. To make a cell reference absolute, you must include a $ before the reference (ex: $C$4).