FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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
A
CONCATENATE
B
Copy and club both in one cell
C
Flash Fill
D
SUMIF
Explanation: 

Detailed explanation-1: -To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.

Detailed explanation-2: -Whenever you need to merge first and last names together in one cell, the fastest way is to concatenate two cells by using the ampersand operator (&) or the CONCATENATE function as shown in the below examples.

Detailed explanation-3: -Select the cell containing the last name (B2). In our example, your formula should now be: =CONCATENATE (A2, , B2). 10. Press the Return Key.

Detailed explanation-4: -Combine data using the CONCAT function Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, “ Family").

Detailed explanation-5: -1. Select a blank cell you will place the concatenation result in, and enter the formula =CONCATENATE(LEFT(A2, 1), B2) (A2 is the cell with the first name, and B2 is the cell with the last name) into it, and press the Enter key.

There is 1 question to complete.
Previous
Next