Arranging Windows:

1. In Excel, what does the "Arrange All" option allow you to do?

    एक्सेल में, "सभी को व्यवस्थित करें" विकल्प आपको क्या करने की अनुमति देता है?

a) Adjust font colors

b) Open multiple workbooks in separate windows and arrange them on the screen

c) Insert decorative elements

d) Change page margins

Correct Answer: b) Open multiple workbooks in separate windows and arrange them on the screen

2. How can you arrange multiple open workbooks horizontally in Excel?

    आप एक्सेल में एकाधिक खुली कार्यपुस्तिकाओं को क्षैतिज रूप से कैसे व्यवस्थित कर सकते हैं?

a) By using the "Cascade" option

b) By pressing Ctrl + H

c) By right-clicking on a worksheet tab d) By changing font styles

Correct Answer: a) By using the "Cascade" option

Splitting Windows:

3.     What is the purpose of splitting windows in Excel?

   एक्सेल में विंडोज़ को विभाजित करने का उद्देश्य क्या है?

a) To adjust paragraph spacing

b) To divide a worksheet into separate resizable panes for easier viewing and scrolling

c) To change the font size

d) To insert decorative elements

Correct Answer: b) To divide a worksheet into separate resizable panes for easier viewing and scrolling

4.     How can you split a worksheet into two vertical panes in Excel?

   आप Excel में किसी वर्कशीट को दो ऊर्ध्वाधर पैन में कैसे विभाजित कर सकते हैं?

a) By pressing Ctrl + S

b) By adjusting page margins

c) By using the "Split" command on the View tab

d) By changing font colors

Correct Answer: c) By using the "Split" command on the View tab

Freeze Pane:

5.     What does the "Freeze Panes" feature in Excel allow you to do?

     एक्सेल में "फ़्रीज़ पैन्स" सुविधा आपको क्या करने की अनुमति देती है?

a) Adjust the font style of selected cells

b) Lock specific rows or columns in place while scrolling through a worksheet

c) Apply decorative borders to cells

d) Delete rows and columns

Correct Answer: b) Lock specific rows or columns in place while scrolling through a worksheet

6.     How can you freeze both rows and columns in Excel?

    आप Excel में पंक्तियों और स्तंभों दोनों को कैसे फ़्रीज़ कर सकते हैं?

a) By pressing Ctrl + F

b) By right-clicking on a cell and selecting "Freeze Panes"

c) By using the Page Setup menu

d) By adjusting line spacing

Correct Answer: b) By right-clicking on a cell and selecting "Freeze Panes"

Zoom Option:

7.     In Excel, what is the purpose of the Zoom slider in the status bar?

       एक्सेल में, स्टेटस बार में ज़ूम स्लाइडर का उद्देश्य क्या है?

a) To change the font color of the worksheet

b) To quickly adjust the zoom level for better visibility

c) To insert decorative elements

d) To change page margins

Correct Answer: b) To quickly adjust the zoom level for better visibility

8.     How can you customize the zoom level in Excel to fit more or less content on the screen?

     आप स्क्रीन पर कम या ज्यादा सामग्री फिट करने के लिए एक्सेल में ज़ूम स्तर को कैसे अनुकूलित कर सकते हैं?

a) By pressing Ctrl + Z

b) By using the Page Layout menu

c) By right-clicking on a cell and selecting "Zoom Options"

d) By adjusting the Zoom slider or entering a specific percentage in the Zoom dialog box

Correct Answer: d) By adjusting the Zoom slider or entering a specific percentage in the Zoom dialog box

Page Layout:

9.     What does the "Page Layout" view in Excel allow you to do?

       एक्सेल में "पेज लेआउट" दृश्य आपको क्या करने की अनुमति देता है?

a) Adjust font sizes for the entire worksheet

b) Insert decorative elements on each page

c) View and adjust how the worksheet will appear when printed

d) Delete all content on the worksheet

Correct Answer: c) View and adjust how the worksheet will appear when printed

10.  How can you access the "Page Layout" view in Excel?

    आप Excel में "पेज लेआउट" दृश्य तक कैसे पहुंच सकते हैं?

a) By pressing Ctrl + P

b) By right-clicking on a cell and selecting "Page Layout"

c) By using the Page Layout tab on the ribbon

d) By changing font styles

Correct Answer: c) By using the Page Layout tab on the ribbon

Scaling to Fit:

11.  In Excel, what does the "Scale to Fit" option allow you to do?

   एक्सेल में, "स्केल टू फ़िट" विकल्प आपको क्या करने की अनुमति देता है?

a) Adjust paragraph spacing

b) Automatically adjust the column width and row height to fit the content on a printed page

c) Change the font color of the entire worksheet

d) Insert decorative borders around the worksheet

Correct Answer: b) Automatically adjust the column width and row height to fit the content on a printed page

12.  How can you access the "Scale to Fit" options in Excel?

    आप एक्सेल में "स्केल टू फिट" विकल्पों तक कैसे पहुंच सकते हैं?

a) By using the Page Layout menu

b) By right-clicking on a cell and selecting "Scale to Fit"

c) By pressing Ctrl + S d) By adjusting page margins

Correct Answer: a) By using the Page Layout menu

Sheet Options:

13.  What is the purpose of sheet options in Excel?

      एक्सेल में शीट विकल्प का उद्देश्य क्या है?

a) To change the font style of the entire workbook

b) To insert decorative elements on each sheet

c) To customize settings specific to each worksheet, such as headers and footers

d) To delete all worksheets in the workbook

Correct Answer: c) To customize settings specific to each worksheet, such as headers and footers

14.  In Excel, how can you access the sheet options for a specific worksheet?

    एक्सेल में, आप किसी विशिष्ट वर्कशीट के लिए शीट विकल्पों तक कैसे पहुंच सकते हैं?

a) By using the Page Setup menu

b) By pressing Ctrl + O

c) By right-clicking on the sheet tab and selecting "Sheet Options"

d) By adjusting line spacing

Correct Answer: a) By using the Page Setup menu

15.  In Excel, how can you switch between open workbooks when using the "Arrange All" feature?

    एक्सेल में, "अरेंज ऑल" सुविधा का उपयोग करते समय आप खुली कार्यपुस्तिकाओं के बीच कैसे स्विच कर सकते हैं?

a) By pressing Ctrl + A

b) By adjusting paragraph spacing

c) By using the "Windows" menu on the ribbon

d) By changing font colors

Correct Answer: c) By using the "Windows" menu on the ribbon

16.  What is the benefit of using the "Arrange All" feature in Excel when working with multiple open workbooks?

 एकाधिक खुली कार्यपुस्तिकाओं के साथ काम करते समय एक्सेल में "सभी को व्यवस्थित करें" सुविधा का उपयोग करने का क्या लाभ है?

a) It automatically saves all workbooks.

b) It allows you to see and work on all open workbooks simultaneously.

c) It changes the font style of the workbooks.

d) It inserts decorative elements into the workbooks.

Correct Answer: b) It allows you to see and work on all open workbooks simultaneously.

Splitting Windows :

17.  In Excel, how can you remove a split window and return to a single, normal view?

    एक्सेल में, आप स्प्लिट विंडो को कैसे हटा सकते हैं और एकल, सामान्य दृश्य पर वापस लौट सकते हैं?

a) By pressing Ctrl + W

b) By right-clicking on a cell and selecting "Remove Split"

c) By adjusting page margins

d) By changing font styles

Correct Answer: b) By right-clicking on a cell and selecting "Remove Split"

Zoom Option :

18.  In Excel, what is the maximum zoom percentage that can be selected using the Zoom slider in the status bar?

  एक्सेल में, स्टेटस बार में ज़ूम स्लाइडर का उपयोग करके अधिकतम ज़ूम प्रतिशत कितना चुना जा सकता है?

a) 100%

b) 200%

c) 400%

d) Unlimited

Correct Answer: c) 400%

Page Layout :

19.  When using the "Page Layout" view in Excel, what is the purpose of the "Page Break Preview" option?

    एक्सेल में "पेज लेआउट" दृश्य का उपयोग करते समय, "पेज ब्रेक प्रीव्यू" विकल्प का उद्देश्य क्या है?

a) To adjust font colors

b) To provide a decorative view of the worksheet

c) To visualize and customize page breaks for printing

d) To delete rows and columns

Correct Answer: c) To visualize and customize page breaks for printing

Scaling to Fit :

20.  In Excel, what is the purpose of the "Fit to Page" option in the "Scale to Fit" settings?

      एक्सेल में, "स्केल टू फिट" सेटिंग्स में "फिट टू पेज" विकल्प का उद्देश्य क्या है?  

a) To adjust line spacing in the worksheet

b) To automatically fit the entire worksheet onto one page for printing

c) To insert decorative elements on each page

d) To change font styles for the entire worksheet

Correct Answer: b) To automatically fit the entire worksheet onto one page for printing

Sheet Options :

21.  How can you set a specific header and footer for a worksheet in Excel?

   आप एक्सेल में वर्कशीट के लिए एक विशिष्ट शीर्षलेख और पादलेख कैसे सेट कर सकते हैं?

a) By pressing Ctrl + H

b) By using the Page Layout menu

c) By right-clicking on the sheet tab and selecting "Header & Footer"

d) By adjusting paragraph spacing

Correct Answer: c) By right-clicking on the sheet tab and selecting "Header & Footer"

22.  In Excel, what is the purpose of the "Gridlines" option in the "Sheet Options" settings?

    एक्सेल में, "शीट विकल्प" सेटिंग्स में "ग्रिडलाइन्स" विकल्प का उद्देश्य क्या है?

a) To adjust font colors

b) To display or hide gridlines in the printed worksheet

c) To insert decorative elements on each sheet

d) To delete all content in the worksheet

Correct Answer: b) To display or hide gridlines in the printed worksheet

23.  What happens when you select the "Print" option in the "Page Layout" view in Excel?

  जब आप एक्सेल में "पेज लेआउट" दृश्य में "प्रिंट" विकल्प चुनते हैं तो क्या होता है?

a) The worksheet is automatically saved.

b) The worksheet is printed using the default printer settings.

c) The worksheet font styles are changed.

d) The worksheet is deleted.

Correct Answer: b) The worksheet is printed using the default printer settings.

24.  In Excel, what does the "Page Order" option in the "Sheet Options" settings allow you to control?

   एक्सेल में, "शीट विकल्प" सेटिंग्स में "पेज ऑर्डर" विकल्प आपको क्या नियंत्रित करने की अनुमति देता है?

a) The order of sheets within a workbook

b) The order of rows and columns on a worksheet

c) The order of font styles used in the worksheet

d) The order of cell formatting

Correct Answer: a) The order of sheets within a workbook

25.  How can you set a specific print area for a worksheet in Excel?

 आप एक्सेल में वर्कशीट के लिए एक विशिष्ट प्रिंट क्षेत्र कैसे सेट कर सकते हैं?

a) By pressing Ctrl + P

b) By using the Page Setup menu

c) By right-clicking on the sheet tab and selecting "Set Print Area"

d) By adjusting line spacing

Correct Answer: c) By right-clicking on the sheet tab and selecting "Set Print Area"