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 commands is given to reboot the computer?
Which of the following commands is given to reboot the computer? कम्प्यूटर को Reboot करने...
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...
java is a (an)
java is a (an) – जावा होता है एक-
The MULTICS operating system was written in which programming language ?
The MULTICS operating system was written in which programming language ? MULTICS ऑपरेिटंग सिस्टम किस...
Which of the following is not an example of a word processor?
Which of the following is not an example of a word processor? निम्नलिखित में से...
What is the difference between dragging
What is the difference between dragging text with the mouse (left-click) and Ctrl + dragging...
What is the primary purpose of the
What is the primary purpose of the American Standard Code for Information Interchange (ASCII)? अमेरिकन...