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

Share Report

Which tab on the main MS Word ribbon houses the commands to build an automatic Table of Contents, manage citations, and insert a bibliography?

A. Review Tab

B. Design Tab

C. References Tab

D. Insert Tab

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The References tab centralizes all academic document tools, including table of contents builders, footnote managers, and index compilation utilities.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which formula will return '5' from the text 'Excel5'?

A. =RIGHT("Excel5",1)

B. =LEN("Excel5")

C. =MID("Excel5",2,1)

D. =LEFT("Excel5",1)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
RIGHT with 1 character returns '5'. LEFT returns 'E', MID could return 'x'.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, the shortcut to insert a hyperlink is:

A. Ctrl + H

B. Ctrl + K

C. Ctrl + L

D. Alt + K

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl+K hyperlink.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs