Download Microsoft.77-888.BrainDumps.2018-12-21.35q.tqb
| Vendor: | Microsoft |
| Exam Code: | 77-888 |
| Exam Name: | Excel 2010 Expert |
| Date: | Dec 21, 2018 |
| File Size: | 2 MB |
Demo Questions
Question 1
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.
- Under Macro Settings in the Macro Settings category, click Enable all macros, and then click OK.
- Switch to Excel and save the workbook with the .xslm extension as a macro-enabled workbook and close it.
- Reopen the workbook.
- Click OK in the message box.
Correct answer: BCD
Question 2
Which of the following steps will you take to merge copies of a shared workbook? Each correct answer represents a part of the solution. Choose all that apply.
- In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK.
- Click Compare and Merge Workbooks on Quick Access Toolbar.
- Open the copy of the shared workbook to merge the changes.
- Save the workbook if prompted.
- Add Compare and Merge Workbooks.
- Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.
Correct answer: ABCDE
Explanation:
Take the following steps to merge copies of a shared workbook:Add Compare and Merge Workbooks. Open the copy of the shared workbook to merge the changes. Click Compare and Merge Workbooks on Quick Access Toolbar. Save the workbook if prompted. In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK. Take the following steps to merge copies of a shared workbook:
- Add Compare and Merge Workbooks.
- Open the copy of the shared workbook to merge the changes.
- Click Compare and Merge Workbooks on Quick Access Toolbar.
- Save the workbook if prompted.
- In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK.
Question 3
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
- History tracking
- Onscreen highlighting
- Slicer-enabled highlighting
- Reviewing of changes
Correct answer: ABD
Explanation:
The following ways are provided by Excel to access and use the stored change history:Onscreen highlighting: It is used when a workbook does not contain many changes and a user wants to see all changes at a glance.History tracking: It is used when a workbook has many changes and a user wants to investigate what occurred in a series of changes.Reviewing of changes: It is used when a user is evaluating comments from other users. Answer option C is incorrect. This is an invalid answer option. The following ways are provided by Excel to access and use the stored change history:
- Onscreen highlighting: It is used when a workbook does not contain many changes and a user wants to see all changes at a glance.
- History tracking: It is used when a workbook has many changes and a user wants to investigate what occurred in a series of changes.
- Reviewing of changes: It is used when a user is evaluating comments from other users. Answer option C is incorrect. This is an invalid answer option.
