DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cell and range names can use uppercase and lowercase letters, digits, and spaces.
|
|
True
|
|
|
FalseWhat is not allowed when naming a cell or range?What are the rules for naming cells or ranges?How is a cell or range of cells named?What are valid range names in Excel?What is not a valid range name in Excel?What character is not allowed in range names in Excel?What is the correct way to write a cell range?What is called cell range?Can we name a cell range?Is the cell range names are case sensitive True or false?How do you use a range name in Excel?
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -To create a named range, simply select a cell or cell range, then type the desired name into the Name box (to the left of the formula bar). You can then use the new name whenever you want to refer to that cell range. Watch the video below to learn how to create and use named ranges.
Detailed explanation-3: -The first character of a Named Range should be a letter and underscore character( ), or a backslash(
There is 1 question to complete.