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 keyboard shortcut is used to switch to the last tab in the Chrome browser?
Which keyboard shortcut is used to switch to the last tab in the Chrome browser?...
“MOD” function in Excel is used for-
“MOD” function in Excel is used for- एक्सेल में ”MOD” फंक्शन (फलन)………….. के लिए प्रयोग...
Which of the following protocols is
Which of the following protocols is used for communication over the Internet? इंटरनेट पर संचार...
The file created through word processing is called…………?
The file created through word processing is called…………? वर्ड प्रोसेसिंग के जरिए क्रिएट की जाने...
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...
Which keyboard shortcut is used to open an already existing document (doc) file in MS Word?
Which keyboard shortcut is used to open an already existing document (doc) file in MS...
In MS Excel, which tab is generally used to open and save a spreadsheet?
In MS Excel, which tab is generally used to open and save a spreadsheet? एमएस...