arrow
arrow
arrow
The _____ feature of MS Excel quickly completes a series of data.
Question

The _____ feature of MS Excel quickly completes a series of data.

A.

Auto Complete

B.

Auto Fill

C.

Fill Handle

D.

Sorting

Correct option is B

✅ (b) Auto Fill:
· The Auto Fill feature in MS Excel helps to quickly complete or extend a series of data automatically.
· It allows users to fill adjacent cells with values following a pattern or sequence based on the initial input.
· For example, if you enter “January” in a cell and drag the fill handle, Auto Fill will complete the series with “February,” “March,” etc.
· This feature saves time and reduces manual data entry errors.
· Auto Complete suggests entries based on previously entered data but does not fill series.
· Fill Handle is the tool (small square) used to drag and apply Auto Fill, not the feature itself.
· Sorting arranges data but does not fill series.
❌ (a) Auto Complete: Used for text suggestions, not series completion. ❌ (c) Fill Handle: Tool used to apply Auto Fill, but not the feature name. ❌ (d) Sorting: Organizes data, does not fill series.

Free Tests

Free
Must Attempt

Fundamentals of Food Safety: Definitions, Additives & Contaminants

languageIcon English
  • pdpQsnIcon30 Questions
  • pdpsheetsIcon30 Marks
  • timerIcon27 Mins
languageIcon English
Free
Must Attempt

UPSSSC Cane Supervisor Full Length Mock 01

languageIcon English
  • pdpQsnIcon100 Questions
  • pdpsheetsIcon100 Marks
  • timerIcon120 Mins
languageIcon English
Free
Must Attempt

CUET PG Agribusiness Management (ABM) Full Mock Test : 01

languageIcon English
  • pdpQsnIcon75 Questions
  • pdpsheetsIcon300 Marks
  • timerIcon90 Mins
languageIcon English
test-prime-package

Access ‘STATE FOOD SAFETY OFFICER FSO’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
354k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow