Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)? MCQ with Answer and Explanation

Question

Share Report Error

Which Excel feature allows you to automatically fill cells with a series (e.g., 1,2,3 or Mon,Tue,Wed)?

A. Goal Seek

B. Data Validation

C. Flash Fill

D. AutoFill handle

Answer: Option D

Solution (By JKSSB Mock Tests)

Dragging the fill handle (small square at bottom-right) creates series. Flash Fill detects patterns.

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

What is the shortcut key to move between open workbooks in Excel?

A. Both A and B

B. Alt + Tab

C. Ctrl + Tab

D. Ctrl + F6

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In Excel, Ctrl+Tab and Ctrl+F6 both cycle through open workbooks. Alt+Tab switches between all open applications.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, the 'Thesaurus' tool is available under which tab?

A. References

B. Insert

C. Home

D. Review

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Thesaurus is located in the Review tab, in the Proofing group. It provides synonyms and antonyms.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, to add a sound that plays across multiple slides, use:

A. Transitions -> Sound

B. Audio Tools Playback -> Play Across Slides

C. Animations -> Sound

D. Insert -> Audio -> Play Across

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Play Across Slides under Playback tab.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs