Question

What is flash fill feature? How can it be applied?

4. What is Auto Fill? Explain it with an example?​

Answer 1

Answer:

Flash fills automatically fills data when it senses a pattern for example you can use flash file to separate first and last name from a single column or combine first and last names from two different columns.

Auto fill is a software function that completes data in browser forms without the user needing to type it in full.

Spreadsheet Auto fill is an example of auto fill.

for example if you enter one in cell A1 then drag the fill handle downwards, autofill will automatically fill in the selected cells with the number 1 . If you enter 1 in a A1 and 2 in A2 then select both A1 and A2 then drag the fill handle downwards, it will increment the values in the cells.