Instantly download 77-882 training test engine

Sally works as an Accounts Administrator at ABC.com. She is using Microsoft Office Excel 2010 to edit a workbook.
The workbook contains four worksheets as shown below.

Sally selects all four worksheets as shown below.

Sally wants to cancel the selection so she clicks on one of the worksheets. However, the four worksheets remain selected.
Sally calls you and asks how to cancel the selection.
Which two of the following options could you advise Sally to do? Choose two. Each answer represents a complete solution.

• A. You could advise Sally to click on an selected worksheet.
• B. You could advise Sally to click on the tab of any of the worksheets.
• C. You could advise Sally to right-click on the tab of a worksheet and select the Ungroup Sheets option.
• D. You could advise Sally to double-click on one of the worksheets.

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
You have data on three worksheets in the financial report. A formula in a cell on the third worksheet pulls data from cells in the first and second worksheets in the workbook.
You want to view the value of the cell containing the formula while you make changes to the values of cells in the first worksheet.
How can you view the value of the cell containing the formula on Sheet3 while working on Sheet1?

• A. You should consider making use of the Show Formulas function on the Formulas tab.
• B. You should consider making use of the New Window function on the View tab.
• C. You should consider making use of the Watch Window function on the Formulas tab.
• D. You should consider making use of the Lookup and Reference function on the Formulas tab.

You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in
Excel 2010. Before creating a final report, you are required to test some logical conditions. You
enter test data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following
conditional formulas will return "True"?

• A. =OR(E3>E4, E3<E5)
• B. =NOT(E3+E4=34)
• C. =AND(E3>E4, E3<E5)
• D. =AND(E3<E4, E3>E5)

Your work at ABC.com includes the preparation of workbooks using Microsoft Office Excel 2010.
You have finished a lengthy report about product sales for the past year and project sales for the next year. The workbook lists the name of a product multiple times.
The company releases a new version of the product and the product name is changed to reflect the update.
You want to use the Replace dialog box to change every instance of the product name throughout the spreadsheet.
Which of the following key combinations opens the Replace dialog box?

• A. Ctrl + F
• B. Ctrl + B
• C. Ctrl + R
• D. Ctrl + H

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
The workbook will be used to track deployments of the company's product to customers. The workbook will be updated by members of the deployment team and by other users in the Sales department.
You need to restrict the type of information that users can enter into the workbook. You want to ensure that customer's names are spelt correctly by using a list for users to select from and you want to limit the cells that users can enter numbers into. You also want users to be presented with a message when they enter invalid data.
Which function of Excel should you use?

• A. You should use the Data Validation function on the Data tab.
• B. You should use the Protect Workbook function on the Review tab.
• C. You should use the Format function on the Home tab.
• D. You should use the Data Consolidation function on the Data tab.