DATABASE FUNDAMENTALS
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: An absolute cell reference is one that does not change when it is copied.
Detailed explanation-5: -Keep formula cell reference constant with the F4 key 1. Select the cell with the formula you want to make it constant. 2. In the Formula Bar, put the cursor in the cell which you want to make it constant, then press the F4 key.