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

Microsoft 77-882 問題練習

Excel 2010 試験

最新更新時間: 2020/11/16,合計64問。

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

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

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

 / 5

Question No : 1
You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in Microsoft Excel 2010. You have to insert a Venn-diagram in a worksheet. Mark the option you will choose to accomplish the task.

正解:

Question No : 2
Rick works as an Office Executive for Perfect Wear Inc. He uses Microsoft Excel 2010 to maintain sales record of each day. He needs to print the daily sales report. The management of the company wants to ensure that each crucial report printed, must print a picture named conf.gif as a watermark showing the confidential message.
Which of the following options should he use to accomplish the task?

正解:

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



You want to insert formulas in the cells in the First Quarter column. These cells will display the sum of values of respective columns in January, February, and March columns. For this, you insert the following formula in the E2 cell: =sum(B2:D2)
However, Excel is treating the formula as a text and displaying it in the following format:



What is the most likely cause?

正解:

Question No : 4
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010. The report worksheet will include the sales made by all the sales managers in the month of January.




In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?

正解:

Question No : 5
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?

正解:

Question No : 6
You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets changes. She requests you to help her out to accomplish the task. Which of the following steps will you advice her to accomplish the task?

正解:

Question No : 7
You are creating a business report by using Microsoft Excel 2010. You have arranged sales data as shown below:



You want to provide pictorial representation of the trend of these sales data in front of each row. Which of the following steps will you choose to accomplish the task involving the least amount of administrative burden?

正解:

Question No : 8
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. You have selected all worksheets available in the workbook as shown below:



Now, you want to cancel the selection. Which of the following steps will you take to accomplish the task with least administrative effort?

正解:

Question No : 9
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will choose to accomplish the task.

正解:

Question No : 10
You work as a Sales Manager for Net World Inc. You are creating a sales report in Microsoft Excel 2010. You want to create the report while keeping an eye on how it will look in printed format. Which of the following views will you have to work on?

正解:

Question No : 11
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?

正解:

Question No : 12
You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales reports for the Sales department. You use Microsoft Excel 2010 to create these reports. You have created an yearly sales report. The fragment of the report is shown below:



As the report is quite wide, printing this report involves three A4 size pages. You want the first
column (column A) to repeat in every printed page. Mark the option that you will choose to
accomplish the task.

正解:

Question No : 13
You have upgraded your Excel 2007 to Excel 2010. You want to personalize your Excel environment through the Excel Options window given below:



You are unable to find the Office button. Choose the steps you will take to accomplish the task.



正解:

Question No : 14
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open the application and see various changes in Excel 2010. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.

正解:

Question No : 15
You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have
inserted the following formula in a cell:
VLOOKUP(12, A2:C10, 3, FALSE )
Which of the following actions will be performed by the formula?

正解:

 / 5