DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
fill handle
|
|
|
autosum
|
|
|
autofill
|
|
|
autocopy
|
Detailed explanation-1: -Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns.
Detailed explanation-2: -In Microsoft Excel, AutoFill is a feature that allows the user to extend a series of numbers, dates, or even text to the necessary range of cells. This little option gives you plenty of possibilities. Use Flash Fill in Excel, autofill dates and numbers, populate numerous cells, and get custom list values.
Detailed explanation-3: -Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill.
Detailed explanation-4: -AutoFill in excel can fill a range in a specific direction by using the fill handle. The range is filled with values (numerical, textual or a mix) which are either copied from the initially selected cell or based on the pattern of the selected cells.