In Excel, what does the 'Flash Fill' feature do? MCQ with Answer and Explanation

In Excel, what does the 'Flash Fill' feature do?
A. Fills cells with a series like AutoFill
B. Automatically fills values by detecting patterns
C. Copies formatting from adjacent cells
D. Fills a range with random numbers
Answer: Option B
Solution (By JKSSB Mock Tests)
Flash Fill (Ctrl+E) extracts, combines, or formats data based on examples.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS PowerPoint, which tool allows an author to capture formatting configurations, borders, and effects from an image and apply those same properties to another image asset?
A. Animation Painter
B. Theme Styles manager
C. Format Painter
D. Design Master

Correct Answer: Option C


Explanation:
The Format Painter tool copies visual style formatting (such as borders, shadows, and fills) from a selected object and applies it to another asset with a single click.

This question belongs to: Computer Microsoft Office
Question #2
In Excel, the IF function belongs to which category?
A. Text
B. Logical
C. Math & Trig
D. Statistical

Correct Answer: Option B


Explanation:
IF is a logical function. Other logical functions: AND, OR, NOT.

This question belongs to: Computer Microsoft Office
Question #3
What is the shortcut key to insert a new slide in MS PowerPoint?
A. Ctrl + D
B. Ctrl + N
C. Ctrl + Shift + N
D. Ctrl + M

Correct Answer: Option D


Explanation:
Ctrl+M inserts a new slide. Ctrl+N creates a new presentation. Ctrl+D duplicates slide.

This question belongs to: Computer Microsoft Office