FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Flash Fill can separate labels (such as names or addresses) into different columns or combine labels from several columns into one.
A
T
B
F
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -If you establish a pattern by typing the full name in column C, Excel’s Flash Fill feature will fill in the rest for you based on the pattern you provide. Enter the full name in cell C2, and press ENTER. Go to Data > Flash Fill, or press Ctrl+E. Excel will sense the pattern you provided in C2, and fill the cells below.

There is 1 question to complete.