If you use the Fill Handle to drag the cell containing ‘Q1’ in MS Excel,
If you use the Fill Handle to drag the cell containing ‘Q1’ in MS Excel, what happens?
यदि आप एमएस एक्सेल में ‘Q1’ वाले सेल को ड्रैग करने के लिए फिल हैंडल (Fill Handle) का उपयोग करते हैं, तो क्या होता है?
Detailed Solution & Logic
Cells will be filled with ‘Q1’, ‘Q2’, ‘Q3’, ‘Q4’, and then Excel will repeat the sequence./ सेल 'Q1', 'Q2', 'Q3', 'Q4', से फिल हो जाएंगे, और फिर एमएस एक्सेल उस अनुक्रम को रिपीट करेगा।
Explanation / व्याख्या:
In MS Excel, the Fill Handle is a small square at the bottom-right corner of a selected cell. It is used to copy or continue a series of values.
-
If the cell contains ‘Q1’, Excel recognizes it as part of a custom sequence like Q1, Q2, Q3, Q4.
-
जब आप ‘Q1’ को Fill Handle से खींचते हैं, Excel क्रमशः Q2, Q3, Q4 और फिर इस पैटर्न को दोहराता है।
-
-
This is useful for quarterly data, labels, or repeating sequences.
Other options explained:
-
All cells will contain ‘Q1’ / सभी सेल के लिए सेल कंटेंट 'Q1' रहेगी – ❌ This happens only if you hold Ctrl while dragging in some cases, otherwise Excel continues the sequence.
-
अगर Ctrl नहीं दबाया तो Excel सीक्वेंस बढ़ाता है।
-
-
Cells will be filled with consecutive numbers / सेल क्रमागत संख्याओं से फिल हो जाएंगे – ❌ Only happens if the original cell has a number.
-
‘Q1’ में नंबर नहीं है, इसलिए यह सही नहीं है।
-
-
Cells will remain blank / सेल ब्लैंक रह जाएंगे – ❌ ❌ Wrong, because the Fill Handle actively fills the cells.
Extra Facts / अतिरिक्त तथ्य:
-
Fill Handle can also be used for dates, numbers, custom lists (like days of the week or months).
-
You can hold Ctrl while dragging to copy the exact value instead of continuing the series.
-
Using Auto Fill Options, you can choose whether to fill formatting only, fill series, or fill without formatting.
Similar Practice Questions
Which of the following is the correct
Which of the following is the correct way to start a new blank presentation in...
What happens when you place the cursor in the last cell of a table in an MS Word document and press the TAB key?
What happens when you place the cursor in the last cell of a table in...
Which of the following is not a web browser?
Which of the following is not a web browser? निम्नलिखित में से कौन एक वेब...
Which of the following operating systems is open-source and is often used in server environments?
Which of the following operating systems is open-source and is often used in server environments?...
Which one is NOT the method to search
Which one is NOT the method to search for and replace text in Microsoft Word?...
In Windows OS, which run command is used to open
In Windows OS, which run command is used to open the Optional Features pane in...
Which of the following file management tools allows users to browse and manage files in Windows OS?
Which of the following file management tools allows users to browse and manage files in...