最新的Microsoft Excel 2010 Expert - 77-888免費考試真題
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for creating various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell.
Which of the following formulas will provide the required result?
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell.
Which of the following formulas will provide the required result?
正確答案: C,E
說明：（僅 Fast2test 成員可見）
You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?
正確答案: D
說明：（僅 Fast2test 成員可見）
You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team
Using Microsoft Excel. You want the report to appear in the following format:
You want the Remark column to be filled through a conditional formula. The criteria to give the
remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the
sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?
Using Microsoft Excel. You want the report to appear in the following format:
You want the Remark column to be filled through a conditional formula. The criteria to give the
remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the
sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?
正確答案: B
說明：（僅 Fast2test 成員可見）
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to make a slicer available for use in another PivotTable. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
Each correct answer represents a part of the solution. Choose all that apply.
正確答案: A,C
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.
Which of the following options will you choose to accomplish the task?
Which of the following options will you choose to accomplish the task?
正確答案: A
說明：（僅 Fast2test 成員可見）
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. Which of the following are the reasons that are causing the above problem?
Each correct answer represents a complete solution. Choose all that apply.
Each correct answer represents a complete solution. Choose all that apply.
正確答案: B,C
說明：（僅 Fast2test 成員可見）
HOTSPOT
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network.
You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network.
You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.
正確答案:
