Which feature in MS Excel automatically fills adjacent cells when it recognizes a clear data pattern, such as combining first and last names? MCQ with Answer and Explanation

Question

Which feature in MS Excel automatically fills adjacent cells when it recognizes a clear data pattern, such as combining first and last names?

A. Data Validation

B. Consolidate

C. AutoCorrect

D. Flash Fill

Answer: Option D

Solution (By JKSSB Mock Tests)

Flash Fill recognizes structural text patterns and completes data entry down an entire column automatically.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

In PowerPoint, which option allows you to save a presentation as a video?

A. File -> Export -> Create a Video

B. Both A and B

C. Save As -> MP4

D. Slide Show -> Record -> Export

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both Export and Save As can create a video file.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, 'AutoCorrect' is used to:

A. Translate text to another language

B. Check grammar

C. Automatically correct common spelling and typing mistakes as you type

D. Auto-format headings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AutoCorrect fixes typos (e.g., 'teh' to 'the').

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Word, the feature that automatically creates a border when you type three hyphens and press Enter is:

A. AutoFormat As You Type

B. AutoCorrect

C. Smart Lookup

D. Quick Styles

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Typing three hyphens, underscores, or equal signs and Enter triggers automatic border creation.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs