最新的Microsoft Excel 2010 - 77-882免費考試真題
You work as an Office Assistant of Mark World Inc. You have created a report in a workbook in
Excel 2010. You want to change the layout of the worksheet from portrait to landscape. Mark the
option that you will choose to accomplish the task.
Excel 2010. You want to change the layout of the worksheet from portrait to landscape. Mark the
option that you will choose to accomplish the task.
正確答案:
Explanation:
The question specifies that you have to change the layout of the worksheet from portrait to
landscape. The Portrait layout is the default configuration of Excel. The Orientation option in the
Page Setup group of the Page Layout tab is used to switch the pages in portrait of landscape
layouts. In order to accomplish the task, click the Orientation option in the Page Setup group of the
Page Layout tab, and then click the Landscape option.
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?
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
說明：（僅 Fast2test 成員可見）
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You are working on a Sales report for the last quarter. You insert a table into a worksheet and populate the table with the names of the Sales people and their total sales over the last three months.
Which of the following Excel functions can you NOT do if your workbook contains a table?
You are working on a Sales report for the last quarter. You insert a table into a worksheet and populate the table with the names of the Sales people and their total sales over the last three months.
Which of the following Excel functions can you NOT do if your workbook contains a table?
正確答案: D
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?
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?
正確答案: C
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
You want to insert a Hierarchy Table like the one shown below into a worksheet.
Which Excel function should you use to insert a Hierarchy Table?
You want to insert a Hierarchy Table like the one shown below into a worksheet.
Which Excel function should you use to insert a Hierarchy Table?
正確答案: B
You work as an Office Administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook. When completed, the workbook will be sent to other users in the Sales department, company managers and board members.
You have completed the workbook. You want to ensure that all hidden rows and columns, comments and personal information are removed from the workbook before you distribute it.
What should you do before sending the workbook?
You have completed the workbook. You want to ensure that all hidden rows and columns, comments and personal information are removed from the workbook before you distribute it.
What should you do before sending the workbook?
正確答案: D
You work as the Financial Controller at ABC.com. You are using Microsoft Office Excel 2010 to edit multiple workbooks. You have workbooks open from different shared folders on the network.
You want to arrange the workbook windows so that you can view the titles of all the workbooks that you have open.
How should you configure the view?
You want to arrange the workbook windows so that you can view the titles of all the workbooks that you have open.
How should you configure the view?
正確答案: D
You work as an Office Assistant for Pecuniary Inc. You are creating a report in a workbook in
Microsoft Excel. The company borrowed a sum of $1000000 at 6% interest rate, which is to be
paid within 24 months. You are required to prepare a report in a workbook in Microsoft Excel,
which shows the calculation of monthly installments to be paid to repay the loan. Which of the
following formulas will you use to accomplish the task?
Microsoft Excel. The company borrowed a sum of $1000000 at 6% interest rate, which is to be
paid within 24 months. You are required to prepare a report in a workbook in Microsoft Excel,
which shows the calculation of monthly installments to be paid to repay the loan. Which of the
following formulas will you use to accomplish the task?
正確答案: C
說明：（僅 Fast2test 成員可見）
You have been hired as an Accounts Auditor for ABC.com. The Accounts Manager has given you a workbook that he created using Microsoft Office Excel 2010.
The workbook has multiple worksheets and contains several formulas. You select a cell in a worksheet.
How can you view which formulas refer to the cell?
The workbook has multiple worksheets and contains several formulas. You select a cell in a worksheet.
How can you view which formulas refer to the cell?
正確答案: A