Header and Footer:

1.What is the purpose of the "Header and Footer" feature in Excel?

एक्सेल में "हेडर और फूटर" सुविधा का उद्देश्य क्या है?

a) To add decorative elements to worksheets

b) To insert watermarks in worksheets

c) To customize content that appears at the top and bottom of printed pages

d) To protect worksheets from editing

Correct Answer: c) To customize content that appears at the top and bottom of printed pages

2. How can you access the "Header and Footer" settings in Excel?

आप एक्सेल में "हेडर और फूटर" सेटिंग्स तक कैसे पहुंच सकते हैं?

a) By pressing Ctrl + H

b) By using the Page Layout menu

c) By right-clicking on a cell and selecting "Header and Footer"

d) By adjusting page margins

Correct Answer: b) By using the Page Layout menu

Watermark:

3.What is the purpose of adding a watermark to an Excel worksheet?

एक्सेल वर्कशीट में वॉटरमार्क जोड़ने का उद्देश्य क्या है?

a) To protect the worksheet from unauthorized access

b) To insert decorative elements into the worksheet

c) To apply a visible background image or text behind the worksheet content

d) To create comments in the worksheet

Correct Answer: c) To apply a visible background image or text behind the worksheet content

Protect Sheet:

4. In Excel, what does the "Protect Sheet" feature allow you to do?

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

a) Adjust font styles for the entire worksheet

b) Lock specific cells or elements to prevent changes

c) Insert decorative elements into the worksheet

d) Add watermarks to the worksheet

Correct Answer: b) Lock specific cells or elements to prevent changes

5. How can you protect a worksheet in Excel from unauthorized edits?

आप एक्सेल में किसी वर्कशीट को अनधिकृत संपादन से कैसे बचा सकते हैं?

a) By using the "Protect Sheet" feature and setting a password

b) By adjusting paragraph spacing

c) By right-clicking on a cell and selecting "Protect Worksheet"

d) By changing font colors

Correct Answer: a) By using the "Protect Sheet" feature and setting a password

Protect Workbook:

6. What is the primary purpose of the "Protect Workbook" feature in Excel?

एक्सेल में "प्रोटेक्ट वर्कबुक" सुविधा का प्राथमिक उद्देश्य क्या है?

a) To insert decorative elements into the workbook

b) To allow multiple users to edit the same workbook simultaneously

c) To prevent changes to the workbook structure, including adding or deleting sheets

d) To add comments to the workbook

Correct Answer: c) To prevent changes to the workbook structure, including adding or deleting sheets

Protect File:

7. In Excel, what is the primary purpose of protecting a file with a password?

एक्सेल में, किसी फ़ाइल को पासवर्ड से सुरक्षित रखने का प्राथमिक उद्देश्य क्या है?

a) To apply a watermark to the file

b) To lock specific cells within the file

c) To prevent unauthorized access to the entire file

d) To add decorative elements to the file

Correct Answer: c) To prevent unauthorized access to the entire file

Comment:

8.  How can you add a comment to a cell in Excel?

आप एक्सेल में किसी सेल में टिप्पणी कैसे जोड़ सकते हैं?

a) By pressing Ctrl + C

b) By adjusting page margins

c) By right-clicking on the cell and selecting "Insert Comment"

d) By changing font styles in the cell

Correct Answer: c) By right-clicking on the cell and selecting "Insert Comment"

9. What is the primary purpose of adding comments to cells in Excel?

एक्सेल में सेल में टिप्पणियाँ जोड़ने का प्राथमिक उद्देश्य क्या है?

a) To change

the font color of the cell content

b) To insert decorative elements into the cell

c) To provide additional information or context about the cell content

d) To protect the cell from editing

Correct Answer: c) To provide additional information or context about the cell content

Remove Duplicate:

10. In Excel, what does the "Remove Duplicates" feature allow you to do?

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

a) To add decorative elements to worksheets

b) To adjust font styles for selected cells

c) To remove duplicate values from a range of cells

d) To apply watermarks to the worksheet

Correct Answer: c) To remove duplicate values from a range of cells

11.  How can you access the "Remove Duplicates" feature in Excel?

आप एक्सेल में "डुप्लिकेट हटाएं" सुविधा तक कैसे पहुंच सकते हैं?

a) By pressing Ctrl + R

b) By using the Page Layout menu

c) By right-clicking on a cell and selecting "Remove Duplicates"

d) By adjusting paragraph spacing

Correct Answer: c) By right-clicking on a cell and selecting "Remove Duplicates"

Header and Footer :

12. In Excel, what type of content can you typically add to the header and footer?

एक्सेल में, आप आमतौर पर हेडर और फ़ूटर में किस प्रकार की सामग्री जोड़ सकते हैं?

a) Watermarks

b) Decorative elements

c) Text, page numbers, and date/time information

d) Comments

Correct Answer: c) Text, page numbers, and date/time information

13. How can you customize the header and footer separately for odd and even pages in Excel?

आप Excel में विषम और सम पृष्ठों के लिए शीर्ष लेख और पाद लेख को अलग-अलग कैसे अनुकूलित कर सकते हैं?

a) By using the "Odd/Even Page" option in the Page Layout menu

b) By right-clicking on a cell and selecting "Header & Footer Options"

c) By pressing Ctrl + O

d) By adjusting font colors

Correct Answer: a) By using the "Odd/Even Page" option in the Page Layout menu

Watermark :

14.In Excel, what effect does applying a watermark have on the worksheet's actual content?

एक्सेल में वॉटरमार्क लगाने से वर्कशीट की वास्तविक सामग्री पर क्या प्रभाव पड़ता है?

a) It alters the font style of the content.

b) It adds visible background text or images without affecting the content.

c) It deletes the content. d) It encrypts the content.

Correct Answer: b) It adds visible background text or images without affecting the content.

Protect Sheet :

15. When you protect a worksheet in Excel using a password, can you later unprotect it without the password?

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

a) Yes, anytime.

b) No, you cannot unprotect it without the password.

c) Only during weekends.

d) After changing font styles.

Correct Answer: b) No, you cannot unprotect it without the password.

16.  What does it mean when you protect a worksheet and select the option to "Allow all users of this worksheet to" in Excel?

जब आप किसी वर्कशीट को सुरक्षित रखते हैं और एक्सेल में "इस वर्कशीट के सभी उपयोगकर्ताओं को इसकी अनुमति दें" विकल्प का चयन करते हैं तो इसका क्या मतलब है?

a) You allow all users to edit the worksheet without restrictions.

b) You restrict all users from editing the worksheet.

c) You only allow users to view the worksheet.

d) You change the font color of the worksheet.

Correct Answer: a) You allow all users to edit the worksheet without restrictions.

Protect Workbook :

17.  In Excel, what is the primary purpose of protecting a workbook's structure?

एक्सेल में, कार्यपुस्तिका की संरचना की सुरक्षा का प्राथमिक उद्देश्य क्या है?

a) To apply a watermark to the workbook

b) To prevent users from opening the workbook

c) To prevent users from making structural changes like adding or deleting sheets

d) To change the font style of the entire workbook

Correct Answer: c) To prevent users from making structural changes like adding or deleting sheets

18.  How can you protect a workbook's structure in Excel?

आप Excel में किसी कार्यपुस्तिका की संरचना की सुरक्षा कैसे कर सकते हैं?

a) By using the "Protect Workbook" feature and setting a password

b) By inserting decorative elements into the workbook

c) By right-clicking on a cell and selecting "Protect Workbook"

d) By adjusting paragraph spacing

Correct Answer: a) By using the "Protect Workbook" feature and setting a password

Protect File :

19.  In Excel, what happens when you protect a file with a password?

एक्सेल में, जब आप किसी फ़ाइल को पासवर्ड से सुरक्षित करते हैं तो क्या होता है?

a) It adds decorative elements to the file.

b) It changes the font color of the file.

c) It prevents unauthorized access to the entire file.

d) It inserts watermarks into the file.

Correct Answer: c) It prevents unauthorized access to the entire file.

20.  Can you remove a password protection from an Excel file once it's applied?

क्या आप किसी Excel फ़ाइल पर पासवर्ड सुरक्षा लागू होने के बाद उसे हटा सकते हैं?

a) Yes, anytime.

b) No, you cannot remove it without the password.

c) Only on Mondays.

d) After inserting comments.

Correct Answer: b) No, you cannot remove it without the password.

Comment :

21.  In Excel, what is the primary purpose of using comments?

एक्सेल में टिप्पणियों का उपयोग करने का प्राथमिक उद्देश्य क्या है?

a) To adjust font styles for selected cells

b) To add decorative elements to cells

c) To provide additional information or context about specific cells

d) To protect cells from editing

Correct Answer: c) To provide additional information or context about specific cells

22.  How can you edit an existing comment in Excel?

आप एक्सेल में किसी मौजूदा टिप्पणी को कैसे संपादित कर सकते हैं?

a) By pressing Ctrl + E

b) By right-clicking on the cell with the comment and selecting "Edit Comment"

c) By adjusting page margins

d) By changing font colors in the comment

Correct Answer: b) By right-clicking on the cell with the comment and selecting "Edit Comment"

Remove Duplicate :

23.  What happens to duplicate values when you use the "Remove Duplicates" feature in Excel?

जब आप एक्सेल में "डुप्लिकेट हटाएं" सुविधा का उपयोग करते हैं तो डुप्लिकेट मानों का क्या होता है?

a) They are highlighted with a different font color.

b) They are automatically sorted in ascending order.

c) They are removed from the selected range or column.

d) They are converted into comments.

Correct Answer: c) They are removed from the selected range or column.

24.  How can you specify which columns to consider when removing duplicates in Excel?

आप कैसे निर्दिष्ट कर सकते हैं कि एक्सेल में डुप्लिकेट हटाते समय किन कॉलमों पर विचार किया जाए?

a) By adjusting paragraph spacing

b) By right-clicking on a cell and selecting "Column Options"

c) By using the "Columns to Remove" dialog box

d) By selecting the columns of interest in the "Remove Duplicates" dialog box

Correct Answer: d) By selecting the columns of interest in the "Remove Duplicates" dialog box