USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Answer. Answer: Explanation: Named ranges are not case sensitive and they can contain both upper and lower case letters.
Detailed explanation-2: -The first character of a name must be a letter or an underscore character ( ). Remaining characters in the name can be letters, numbers, periods, and underscore characters. In some languages, Excel may replace certain characters with underscores. Spaces are not allowed.
Detailed explanation-3: -Learn about syntax rules for names Tip: You cannot use the uppercase and lowercase characters “C", “c", “R", or “r” as a defined name, because they are used as shorthand for selecting a row or column for the currently selected cell when you enter them in a Name or Go To text box.