Correct Answer:
B. Auto Fill
MS Excel offers various features to streamline data entry and manipulation. Understanding these tools helps in efficient spreadsheet management.
- A: Auto Complete helps complete text entries in a cell based on existing entries in the same column, but it doesn't generate a series of data.
- B: Auto Fill is the correct answer. This feature intelligently recognizes patterns and extends a series of data (like numbers, dates, or days of the week) into adjacent cells, often by dragging the Fill Handle.
- C: Fill Handle is the small square at the bottom-right corner of a selected cell or range that you drag to activate the Auto Fill feature, but it is not the feature itself.
- D: Sorting arranges data in a specific order (e.g., alphabetical or numerical), which is different from completing a series.