IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 77-888 問題集  / 77-888 問題練習

Microsoft 77-888 問題練習

Excel 2010 Expert 試験

最新更新時間: 2020/11/17,合計40問。

いい買物の日:77-888 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、77-888 問題集を使用してください。

 / 3

Question No : 1
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are currently creating a Microsoft Excel 2010 spreadsheet. You are planning to make use of a Form Control in the spreadsheet.
What option best describes a Form Control?

正解:

Question No : 2
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are reviewing ABC.com’s annual budget, which was created using Microsoft Excel 2010. The budget includes the use of the PRICEMAT, and PRICEDISC functions.
What options describe valid PRICEMAT syntax? (Choose all that apply.)

正解:

Question No : 3
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You have received instructions to generate a Microsoft Excel 2010 form. You have also been informed that the design of the form should be flexible. Furthermore, the look, feel, and other features of the form should be modified.
What is the option you should use?

正解:

Question No : 4
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are in the process of reviewing ABC.com’s annual sales report that was created using Microsoft Excel 2010. You only want to view entries pertaining to a certain sales representative, for a certain product. You do not want to sift through unnecessary information, or consume unnecessary man hours.
Which of the following actions should you take?

正解:

Question No : 5
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You have recently created a Microsoft Excel 2010 report that includes a number of PivotTables. All of the PivotTables in the report should have identical filters configured.
You want to achieve this in the easiest way possible.
What option should you use?

正解:

Question No : 6
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed.
ABC.com has recently upgraded their Microsoft Office package from 2007 to 2010. You are currently working with an Excel 2010 report, and would like to save it to a different destination from within Excel. You want to do this in the easiest way possible.
Which of the following actions should you take?

正解:

Question No : 7
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are creating a sales report using Microsoft Excel 2010. You want retrieve a vertical array of cells as a horizontal array.
What function should you use to achieve this?

正解:

Question No : 8
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You have generated a PivotTable report in Microsoft Excel 2010. You are making use of a Slicer to provide interactive filtering.
Subsequent to filtering the information in the PivotTable report, you want to make sure that the slicer is retained but not active.
How will you achieve this?

正解:

Question No : 9
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are in the process of creating a report using Microsoft Excel 2010. You have captured the necessary information, and also inserted a graphic representation of the information.
You are informed that the report will be presented to the board, and should have an expert appearance. You want to achieve this as quickly as possible.
What is the option you should make use of?

正解:

Question No : 10
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You have created a sales report that contains the first and second quarter’s figures for the current year. You want to insert a visual account of the development between the two quarter’s figures. You do not want to increase the space taken up in the worksheet by the report.
How can you accomplish this?

正解:

Question No : 11
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You have been instructed to create an Excel 2010 worksheet that includes three possible budget instances. You have also been informed that, depending on necessity, the solution you choose should be interchangeable.
How would you achieve this?

正解:

Question No : 12
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are creating a sales report using Microsoft Excel 2010. You want to make use of a formula that searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
What function should you include in this formula?

正解:

Question No : 13
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are creating a sales report using Microsoft Excel 2010. The report has a Total column that has a formula configured.
While entering data, you notice that some of the cells in the Total column only display consecutive # symbols.
What action should you use to rectify this?

正解:

Question No : 14
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are creating a sales report using Microsoft Excel 2010. You want to make sure that each product’s sales are added up using the least amount of effort.
How would you achieve this?

正解:

Question No : 15
You are employed as an office administrator at ABC.com. All workstations in ABC.com’s office have Windows 7 installed, and run Microsoft Office 2010.
You are working in a Microsoft Excel 2010 sales report that contains the sales stats of ABC.com’s top items. You then attempt to reveal the corresponding values for the items.
Your attempt is unsuccessful due to the corresponding value not being identifiable by Microsoft Excel 2010. You want to make sure that you are able to compare data.
What option could you make use of?

正解:

 / 3