FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION 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]

What Excel features uses worksheet data to predict what should be entered into similar column cells?

A	Auto Complete
B	Flash Fill
C	Quick Fill
D	Auto Fill

Explanation:

Detailed explanation-1: -Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.

Detailed explanation-2: -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.

Detailed explanation-3: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.

Detailed explanation-4: -When you’re entering data that has a pattern, like separating a full name into first and last names, you can use the Flash Fill feature in Excel for the web to save time and have Excel fill in the data for you. Type a few examples to show a clear pattern.

There is 1 question to complete.