Page: 1
/ 13
Total 61 questions
You work as a Sales Manager for Young World Inc. You have created a sales report that needs to be submitted to the head office. Before sending the report to your manager, you want to ensure that the integrity of the document is maintained. You also want to place your signature as shown in the image below:
Which of the following steps will you take to accomplish the task?
- A. Insert a Drawing object. Add the signature image to the object. Validate all data entries.
- B. Insert a Signature Line object. Place the digital signature on the Signature Line.
- C. Insert a Text object. Add the signature image to the object. Add a read-only attribute to the workbook.
- D. Insert a WordArt object. Add the signature file to the object. Protect the workbook.
Answer : B
Explanation:
In order to accomplish the task, you will have to take the following steps:
Insert a Signature Line object. This will provide a place to show the digital signature on the document.
Place the digital signature on the Signature Line. This will ensure the integrity of the document, and the image used will be shown in the document.
What is a digital signature? Hide
A digital signature is a technique to authenticate digital documents by using computer cryptography. A digital signature not only validates the sender's identity, but also ensures that the document's contents have not been altered. It verifies that the source and integrity of the document is not compromised since the document is signed. A digital signature provides the following assurances: Authenticity, Integrity, and Non-repudiation. Microsoft
Office 2007 Excel and Word provide a feature known as Signature line to insert a user's digital signature on a document.
You work as an Office Assistant for Pecuniary Inc. You have created a report in a workbook in Excel 2007. You want to quickly format headings and titles in the workbook.
Mark the option that you will choose to accomplish the task.
Answer :
Explanation:
According to the question, you have to quickly format headings and titles in the workbook.
In order to accomplish the task, you will have to take the following steps:
Click the Cell Styles option in the Styles group on the Home tab. This will open the pre- formatted styles available with Excel. Choose the required option.
A cell style is a defined set of formatting characteristics available in Excel, such as fonts and font sizes, number formats, cell borders, and cell shading. A cell style is used to apply several formats quickly. It also ensures that cells have consistent formatting. Microsoft
Office Excel provides several built-in cell styles to apply on cells. Users can also modify these styles to create custom cell styles.
Cell styles are based on the document theme that is applied to the entire workbook. If a user changes the document theme, the cell styles are updated to match the new document theme.
Reference. Microsoft Excel 2007 Help, Contents: "Apply, create, or remove a cell style"
Shelly works as an Office Assistant for Star Publishing Co. She creates a report that includes a list of books, along with the author's name. By mistake, she enters the incorrect spelling of an author's name that appears most often in the whole report. She wants to change incorrect spelling of the author's name with the correct spelling in the whole report.
Choose the option that he will use to accomplish the task.
Answer :
Explanation:
The Replace option on the Edit menu will open the Find and Replace dialog box with the
Replace tab selected. The options under the replace tab are used to find the specific text or number and replace it with the other one on a worksheet.
Perform the following actions in the Find and Replace dialog box to find the specific text or number and replace it with the other one in a worksheet.
1. Enter text or number to be searched in the Find what text box.
2. In the Replace with text box, enter the text or number that will replace text or the number in the Find what text box.
3. Click the Find All or Find Next button.
NOTE. Click the Find All button to get the list of all occurrences of text or the number that is mentioned in the Find what text box.
4. Click the Replace All or Replace button to replace the all occurrences or highlighted occurrence.
NOTE. The following message box will appear if a user clicks the Find All button, and then the
Replace All button.
Reference. Microsoft Excel Help, contents: "Find or replace text and numbers on a worksheet"
Rick works as an Office Assistant for Tech Perfect Inc. He uses Microsoft Excel 2007 for creating reports. He is working on a report in which he has used few macros. He saves the report in macroenabled workbook format. Which of the following extensions will Excel use to save the workbook?
- A. xlsm
- B. xls
- C. xlsx
- D. xlsb
Answer : A
Explanation:
In order to save the macro-enabled workbook, Excel 2007 uses the xlsm extension. The new
Microsoft Office system breaks a file into different groups as document data, macro code, and header information and saves them in separate compartments. It then combines these compartments into a single file. Separating macro code from the data enhances the security of the document. It enables users to prevent Excel 2007 from executing macro codes that possibly can harm computers or data.
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel.
You have selected all worksheets available in the workbook as shown below:
Now, you want to cancel the selection. Which of the following steps will you take to accomplish the task with least administrative effort?
- A. Click on one of the selected sheets.
- B. Double-click on one of the selected sheets.
- C. Click any unselected sheet.
- D. Right-click the selected sheets. Click the Ungroup Sheets option from the shortcut menu.
- E. Click the Single Sheet options in the Sheet Options group on the Page Layout tab.
Answer : D
Explanation:
When multiple sheets are selected, Excel groups the sheet and the [Group] appears in the title bar as shown below:
To unselect the sheet, you are required to click any unselected sheet. However, the question states that all sheets are selected. In such a case, in order to unselect the sheets, you will have to take the following steps:
Right-click the selected sheets.
Click the Ungroup Sheets option from the shortcut menu.
Answer options B and A are incorrect. These options will not ungroup the sheets.
Answer option C is incorrect. The question states that all the sheets are selected. Hence, no unselected sheet will be available.
Answer option E is incorrect. No option such as Single Sheet is available in Excel.
Reference. Microsoft Excel 2007 Help, Contents: "Select one or multiple worksheets"
31 days access 