Q#1: What is the first step to initiate Mail Merge in Microsoft Word?
(A) Click Mailing tab
(B) Click Start Mail Merge
(C) Click on “Next: Select recipients”
(D) Click on “Finish and Merge”
Answer: (B) Click Start Mail Merge
Q#2: After selecting the document type as “Letters,” what should be the next step in Mail Merge?
(A) Click Insert Merge Field
(B) Click on the “Next: Starting document”
(C) Click Close
(D) Click on “Next: Select recipients”
Answer: (B) Click on the “Next: Starting document”
Q#3: How can you create a new mailing list in Mail Merge?
(A) Click on “Next: Select recipients”
(B) Click on “Create…” after selecting “Type a new list”
(C) Click on “Insert Merge Field”
(D) Click on “Finish and Merge”
Answer: (B) Click on “Create…” after selecting “Type a new list”
Q#4: What is the purpose of clicking on the “Finish and Merge” button in the Mail Merge process?
(A) To print documents
(B) To create mailing envelopes
(C) To edit data lists
(D) To finalize the mail merge process
Answer: (D) To finalize the mail merge process
Q#5: How can you edit or add/delete a record in a mailing list in Mail Merge?
(A) Click on the “Insert Merge Field”
(B) Click on “Next: write your letter”
(C) Click on the “Mail recipient” button in the Mailing tab
(D) Click on “Finish and Merge”
Answer: (C) Click on the “Mail recipient” button in the Mailing tab
Q#6: According to the paragraph, what is the main purpose of spreadsheet software like Microsoft Excel?
(A) Creating mailing lists
(B) Editing data lists
(C) Calculating numeric data and applying formats
(D) Merging letters/documents
Answer: (C) Calculating numeric data and applying formats
Q#7: In Microsoft Excel, what represents a cell reference showing a cell address?
(A) Quick Access toolbar
(B) Name Box
(C) Ribbon bar
(D) Formula Bar
Answer: (B) Name Box
Q#8: How can you modify the Ribbon or Quick Access toolbar in MS Excel?
(A) Right-click on the Name Box
(B) Click on “Insert Merge Field”
(C) Right-click on the Ribbon, then go to Customize the Ribbon
(D) Click on “Finish and Merge”
Answer: (C) Right-click on the Ribbon, then go to Customize the Ribbon
Q#9: What is the default format setting for each cell in an Excel spreadsheet?
(A) Text format
(B) General format
(C) Currency format
(D) Percentage format
Answer: (B) General format
Q#10: How can you delete the content of a cell in Microsoft Excel?
(A) Press Backspace
(B) Click on “Insert Merge Field”
(C) Click on “Delete” from the Home tab
(D) Select the cell and press the Delete button
Answer: (D) Select the cell and press the Delete button
Q#11: What is the purpose of the “Wrap text” option under the Home tab in Excel?
(A) To delete cell content
(B) To merge and center cells
(C) To view complete cell content
(D) To change the text, cell color, and style
Answer: (C) To view complete cell content
Q#12: How can you merge and center cells in Microsoft Excel?
(A) Click on “Wrap text”
(B) Select cells, then click on “Merge and Center” under the Home tab
(C) Click on “Insert Merge Field”
(D) Click on “Finish and Merge”
Answer: (B) Select cells, then click on “Merge and Center” under the Home tab
Q#13: In the context of MS Excel, what does the term “workbook” refer to?
(A) A collection of spreadsheets
(B) A cell reference
(C) A formatted text
(D) A new document in Mail Merge
Answer: (A) A collection of spreadsheets
Q#14: How can you save an Excel workbook in the format compatible with Excel 97–2003?
(A) Click on “Save As” and select the desired format
(B) Click on “Insert Merge Field”
(C) Click on “Wrap text”
(D) Click on “Finish and Merge”
Answer: (A) Click on “Save As” and select the desired format
Q#15: What is the function of the “More Number Formats” option in MS Excel?
(A) To merge cells
(B) To convert dollars into PKR
(C) To delete cells
(D) To create a new workbook
Answer: (B) To convert dollars into PKR
Q#16: How can you assign color and name to worksheet tabs in Excel?
(A) Click on “Finish and Merge”
(B) Right-click on the Ribbon
(C) Right-click on the worksheet tab, then choose “Tab Color”
(D) Click on “Insert Merge Field”
Answer: (C) Right-click on the worksheet tab, then choose “Tab Color”
Q#17: What is the purpose of the “Compatibility View” in MS Excel?
(A) To delete cells
(B) To enable old features and disable new features
(C) To merge and center cells
(D) To create mailing envelopes
Answer: (B) To enable old features and disable new features
Q#18: How can you open an existing workbook in Microsoft Excel?
(A) Click on “Finish and Merge”
(B) Click on “Insert Merge Field”
(C) Click on “Save As”
(D) Click on “Open” from the File menu
Answer: (D) Click on “Open” from the File menu
Q#19: In Excel, what is the purpose of the Quick Access toolbar?
(A) To merge cells
(B) To customize the Ribbon
(C) To save a workbook
(D) To delete cells
Answer: (B) To customize the Ribbon
Q#20: How can you calculate values with cell references in Excel?
(A) Click on “Finish and Merge”
(B) Use the “Add, Subtract, Multiply, and Divide” functions
(C) Click on “Insert Merge Field”
(D) Right-click on the Ribbon
Answer: (B) Use the “Add, Subtract, Multiply, and Divide” functions