Discussion
In MS Excel, what does the Flash Fill feature do?
Answer: D
Correct answer: Recognises a pattern from your examples and completes the rest of a column
Flash Fill watches the pattern in what you type and fills the rest of the column to match. Typing the first name from a column of full names, then beginning the second, prompts it to complete every remaining row. It is triggered with Ctrl + E or accepted from the suggestion that appears. It handles splitting, joining, reformatting and case changes without a formula - extracting a domain from an email address, reformatting a phone number, or building initials from names. Its limits are worth knowing. It produces static values, not formulas, so the result does not update when the source changes. It infers the rule from very few examples and can guess wrongly on irregular data, which needs checking. And it works down a column adjacent to the source, not across arbitrary ranges. Where a live result is needed, Text to Columns or text functions such as LEFT, MID and FIND are the alternatives.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development