USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Fill
|
|
|
Flash Fill
|
|
|
Paste Special
|
|
|
Replace Data
|
Detailed explanation-1: -The Flash Fill feature looks for correlation between data that you enter in a column and the adjacent data. If it identifies a pattern of data entry based on the adjacent column, it fills the rest of the column to match the pattern.
Detailed explanation-2: -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-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: -Copy cells by using Copy and Paste Select the cell or range of cells. Select Copy or press Ctrl + C. Select Paste or press Ctrl + V.