Join 60,000+ competitive exam aspirants
Match the options from Group A with Group B regarding Auto Fill Options in MS-Excel sheets:
| Group A | Group B |
|---|---|
| 1. Copy Cells | I. Copy only the cell formatting |
| 2. Fill Formatting Only | II. Copy the entire contents of the cell, including the formulas and the formatting |
| 3. Fill Without Formatting | III. Copy the contents of the cell, including the formulas but not the formatting |
Choose the correct answer from the options given below:
1-II, 2-III, 3-I
1-III, 2-I, 3-II
1-II, 2-I, 3-III
1-I, 2-II, 3-III
II, 2-I, 3-III
In MS-Excel, Auto Fill options determine how data is copied when the fill handle is dragged. 'Copy Cells' duplicates everything, 'Fill Formatting Only' applies visual styles without data, and 'Fill Without Formatting' transfers values/formulas while preserving the destination cell's original aesthetic.
In MS-Excel, Auto Fill options determine how data is copied when the fill handle is dragged. 'Copy Cells' duplicates everything, 'Fill Formatting Only' applies visual styles without data, and 'Fill Without Formatting' transfers values/formulas while preserving the destination cell's original aesthetic.
Think of it like a photocopier: 'Copy Cells' is a full-color scan with text, 'Fill Formatting' is printing a blank template with only the borders and colors, and 'Fill Without Formatting' is copy-pasting the text onto a plain white sheet.
CFW: C (Copy Everything), F (Formatting Only), W (Without Formatting/Just Values).
ValueNewтАЛ=ValueSourceтАЛ тАФ Transfer of raw data
StyleNewтАЛ=StyleSourceтАЛ тАФ Transfer of visual attributes
The Excel engine processes cell data as a set of attributes: value (constant or formula) and style (font, borders, color). When using Auto Fill, the software logic toggles these attributes based on user selection. 'Copy Cells' merges both, 'Fill Formatting' filters the style object, and 'Fill Without Formatting' extracts only the data calculation engine's output.
Copy Cells acts as the default behavior for Auto Fill.
Fill Without Formatting is essential when pasting data into a table with pre-defined alternating row colors.
Formatting includes font properties, cell borders, shading, and number formats.
Efficiently populates large datasets
Maintains data integrity while changing visual presentation
Reduces manual entry errors
Overwriting cell formatting can be difficult to undo without 'Undo' (Ctrl+Z) if multiple actions are performed.
Auto Fill with relative references can lead to unintended calculation errors if not checked.
Standardizing reports by applying consistent formatting to raw data inputs.
Quickly incrementing sequential IDs or dates while maintaining document aesthetics.
The Fill Handle is the small green square in the bottom-right corner of the active cell.
Option D is incorrect because it misaligns the functions of Formatting Only and Without Formatting.
C is correct тАФ 1-II, 2-I, and 3-III correctly pair the Excel Auto Fill actions with their corresponding data-handling outputs.
In competitive exams, focus on the distinction between 'value' and 'format' attributes; most computer application questions test your understanding of how data structures are layered in spreadsheet software.