Question

which statement compares the autofill and flash fill features?
○ only the flash fill feature is based on a recognizable pattern.
○ only the flash fill feature can combine data from other cells.
○ only the autofill feature automatically adds data to the workbook.
○ only the autofill feature is available on the desktop version of excel.

Explanation:

• Analyze each option:
• Option 1: Both AutoFill (e.g., filling a series with a pattern like dates, numbers) and Flash Fill use recognizable patterns. So this is incorrect.
• Option 2: Flash Fill can combine data from other cells (e.g., splitting or combining names, addresses), while AutoFill is more for extending a series or copying a formula/value with a pattern, not typically for combining data from other cells in the same way. This is correct.
• Option 3: Both AutoFill and Flash Fill automatically add data to the workbook. So this is incorrect.
• Option 4: Both features are available in the desktop version of Excel. So this is incorrect.

Answer:

B. Only the Flash Fill feature can combine data from other cells.