77-882試験無料問題集「Microsoft Excel 2010 認定」
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.
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a report on the sales figures for the first quarter.
The report contains the table shown below.
You want to add a column to the table to graphically illustrate the sales trends for each sales person as shown below.
How can you easily create the graphics used in the Trend column?
The report contains the table shown below.
You want to add a column to the table to graphically illustrate the sales trends for each sales person as shown below.
How can you easily create the graphics used in the Trend column?
正解：A
解答を投票する
Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Microsoft Excel
2010. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer
message in the A1 cell of each sheet in the workbook as shown in the image given below:
Which of the following is the easiest way to accomplish the task?
2010. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer
message in the A1 cell of each sheet in the workbook as shown in the image given below:
Which of the following is the easiest way to accomplish the task?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)
You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports.
You have finished creating a monthly company performance report. You will send the document to the company Managing Director when you have finished it.
The Managing Director will need to ensure that the document he receives is the original document that you created. How can you ensure the integrity of the document?
You have finished creating a monthly company performance report. You will send the document to the company Managing Director when you have finished it.
The Managing Director will need to ensure that the document he receives is the original document that you created. How can you ensure the integrity of the document?
正解：B
解答を投票する
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales report.
The report contains the table shown below.
You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?
The report contains the table shown below.
You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?
正解：C
解答を投票する
You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook.
The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month.
You want to enter a value in the cell B2 on each worksheet.
What is the easiest way to insert the same value into the same cell on all worksheets in a workbook?
The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month.
You want to enter a value in the cell B2 on each worksheet.
What is the easiest way to insert the same value into the same cell on all worksheets in a workbook?
正解：A
解答を投票する
You work as Technical Support personnel for Media Perfect Inc. You have created a worksheet in
Excel. The worksheet contains the sales data as shown in the image given below:
You are required to predict the future sales target of Sasha based on her current figures. The future
prediction should be based on linear trend. The chart must be able to predict future sales figure for
at least next three intervals. Take the required steps to accomplish the task.
Excel. The worksheet contains the sales data as shown in the image given below:
You are required to predict the future sales target of Sasha based on her current figures. The future
prediction should be based on linear trend. The chart must be able to predict future sales figure for
at least next three intervals. Take the required steps to accomplish the task.
正解：
Explanation:
According to the question, you are required to summarize the sales data of Sasha and predict her
future sales target based on the current sales figure. The question also states that the future
prediction should be based on linear trend. Furthermore, the chart must predict future sales figure
for at least next three intervals. In order to accomplish the task, you will have to take the following
steps:
Select the chart. Click the Trendline option in the Analysis group on the Layout tab. Click the
More Trendline option. Select the Linear radio-button in the Trend Type section. Provide value 3
for the Forward Forecast period. The linear trendline uses a best-fit straight line to display simple
linear data sets that contain data values that increase or decrease at a steady rate. This type of
trendline uses the following linear equation:
y = mx + b
Here, m is the slope and b is the intercept.
Here, m is the slope and b is the intercept.
It will not forecast the sales figure for next three intervals.
The backward forecast stretches trend line for backward intervals.
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?
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?
正解：C
解答を投票する