DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Under which function we can combine the first and last name
|
|
CONCATENATE
|
|
|
Copy and club both in one cell
|
|
|
Flash Fill
|
|
|
SUMIF
|
Explanation:
Detailed explanation-1: -To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.
Detailed explanation-2: -Select the cell containing the last name (B2). In our example, your formula should now be: =CONCATENATE (A2, , B2). 10. Press the Return Key.
There is 1 question to complete.