If a column has joint-data (such as last name, first name), you can automatically pull sections of the data into a new column by using:

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

If a column has joint-data (such as last name, first name), you can automatically “pull” sections of the data into a new column by using:

A	Flashfill
B	Autofill
C	Merge & Center
D	Copy and Paste

Explanation:

Detailed explanation-1: -To separate first and last names in Excel, highlight your list of names and select Text to columns. In the pop-up window, choose Delimited and select Space from the options. Once finished, Excel should separate all first and last names into different columns.

Detailed explanation-2: -You can go to Data > Flash Fill to run it manually, or press Ctrl+E. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL