77-882 무료 덤프문제 온라인 액세스

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 want to be able to view the changes made to the workbook. You save the workbook to a network location and enable the Track Changes option.
Some users complain that when they open the workbook, it opens in Read Only mode.
How can you ensure that multiple users can open the workbook in Edit mode?

• A.You should consider selecting the Share Workbook option on the Review tab.
• B.You should consider selecting the Protect Workbook option on the Review tab.
• C.You should consider adding a History worksheet to the workbook.
• D.You should consider selecting the Group option on the Data tab.

Martha works as an Office Assistant for Tech Perfect Inc. She uses Microsoft Excel 2010 for
working on a report. She wants to add a picture as a background in her Excel worksheet. She does
not want that picture to be printed while printing. Which of the following steps will she take to
accomplish the task?

• A.Use Insert > Illustrations > Picture to insert the picture
• B.Use Page Layout > Page Setup > Print Titles
• C.Use Page Layout > Page Setup > Background option to insert the picture
• D.Use Insert > Text > Headers & Footers

You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
Some of the cells in a worksheet are formatted using the Heading1 style and some are formatted using the Heading2 style. You select one of the cells formatted with the Heading1 style and press the Delete button on the keyboard.
When you enter some new text into the cell, you discover that the new text is formatted with the Heading1 style. You want to delete the text and the formatting from all the cells formatted with the Heading1 or Heading2 styles.
You select all the formatted cells and select the Clear icon in the Editing group on the Home tab. Which option should you select to delete the formatting and the contents of the selected cells?

• A.You should select the Clear Comments option.
• B.You should select the Clear Contents option.
• C.You should select the Clear Formats option.
• D.You should select the Clear All option.

You work as a Sales Manager for Blue Well Inc. You have to create a report in Excel 2010 in the
following format:

What is the most likely cause?

• A.The document is in the Page Layout view.
• B.Manual Calculation is enabled in the workbook.
• C.Show Formula is enabled in the workbook.
• D.A blank space is inserted before the equal sign (=) in the formula.

You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook. The workbook was created by the Sales Manager who has asked you to fill in the sales figures in the table.
When you click in one of the cells, you see a message as shown below.

What function did the Sales Manager use to configure the alert message?

• A.The Data Validation function.
• B.The Share Workbook function.
• C.The Allow Users to Edit Ranges function.
• D.The Protect Workbook function.