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

Question

Share Report Error

In Excel, what does the 'Flash Fill' feature do?

A. Fills cells with a series like AutoFill

B. Copies formatting from adjacent cells

C. Automatically fills values by detecting patterns

D. Fills a range with random numbers

Answer: Option C

Solution (By JKSSB Mock Tests)

Flash Fill (Ctrl+E) extracts, combines, or formats data based on examples.

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

To quickly find the sum of selected cells in Excel, look at:

A. Formula bar

B. Title bar

C. Status bar

D. Name box

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
When you select numeric cells, the status bar displays Sum, Average, Count.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, to add a new record in a table, you can use:

A. Both A and C

B. SQL INSERT command

C. Design view

D. Datasheet view -> New Record row (asterisk *)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can add records via Datasheet view or via an INSERT query.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, to enforce that a child record cannot be added unless a parent record exists, you set:

A. Enforce Referential Integrity

B. Cascade Update

C. Indexed (No Duplicates)

D. Primary Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Referential Integrity ensures related records exist before allowing entry.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs