DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A spreadsheet cell that does not change regardless of its attributes.
|
Absolute Value
|
|
Function
|
|
Quick Parts
|
|
Styles
|
Explanation:
Detailed explanation-1: -You can also use the shortcut method to take the absolute value of a number in Excel by selecting the cell containing the number and pressing the CTRL+SHIFT+7 keys on your keyboard.
Detailed explanation-2: -There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.
Detailed explanation-3: -A constant is a value that is not calculated; it always stays the same.
There is 1 question to complete.