77-882 無料問題集「Microsoft Excel 2010」
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 want to be able to view the changes made to the workbook. You save the workbook to a network location and enable the Track Changes option.
Some users complain that when they open the workbook, it opens in Read Only mode.
How can you ensure that multiple users can open the workbook in Edit mode?
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 want to be able to view the changes made to the workbook. You save the workbook to a network location and enable the Track Changes option.
Some users complain that when they open the workbook, it opens in Read Only mode.
How can you ensure that multiple users can open the workbook in Edit mode?
正解：B
解答を投票する
You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales
incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a
worksheet for preparing the report. You have inserted the sales figures of all sales managers as
shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total
first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to
the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8
cell. Which of the following formulas will you insert to accomplish the task?
incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a
worksheet for preparing the report. You have inserted the sales figures of all sales managers as
shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total
first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to
the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8
cell. Which of the following formulas will you insert to accomplish the task?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You work as an Office Assistant for Peach Tree Inc. You have created a sales report worksheet in
Excel 2010. In the worksheet, you have created a chart to visually summarize the sales achieved by
Mark:
You want to transfer the chart to a new worksheet named MarkSales. Which of the following steps
will you take to accomplish the task?
Excel 2010. In the worksheet, you have created a chart to visually summarize the sales achieved by
Mark:
You want to transfer the chart to a new worksheet named MarkSales. Which of the following steps
will you take to accomplish the task?
正解：
Explanation:
In order to accomplish the task, you will have to take the following steps: Select the chart.
This task can also be accomplished by taking the following steps:
Select the chart.
Create a new sheet.
Rename the new sheet as MarkSales.
Press Ctrl + X to cut the chart and paste it to the MarkSales sheet by pressing Ctrl + V keys.
However, this will involve more administrative efforts.
You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create company sales reports.
You are creating a sales report for the first quarter of the year. You type a title "First Quarter Sales Report" into cell A1. The title appears as shown below.
You want the title to appear in one line as shown below.
How can you make the title appear on one line?
You are creating a sales report for the first quarter of the year. You type a title "First Quarter Sales Report" into cell A1. The title appears as shown below.
You want the title to appear in one line as shown below.
How can you make the title appear on one line?
正解：B
解答を投票する
You work as a Sales Manager at ABC.com. All users in the Sales department run Microsoft Office 2010 having recently been uABCraded from Microsoft Office 2003.
You are currently working on a Sales report in Microsoft Office Excel 2010.
You maximize the worksheet viewing area by selecting the Full Screen option on the View tab. When you select Full Screen, all toolbars and menus disappear.
How can you restore the worksheet view back to the Normal View so that you can see the toolbars?
You are currently working on a Sales report in Microsoft Office Excel 2010.
You maximize the worksheet viewing area by selecting the Full Screen option on the View tab. When you select Full Screen, all toolbars and menus disappear.
How can you restore the worksheet view back to the Normal View so that you can see the toolbars?
正解：B
解答を投票する
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-byside? Choose two.
The first worksheet in the financial report contains sales figures for each Sales person for the first quarter of the year. The second worksheet contains sales figures for each Sales person for the second quarter of the year. The third worksheet contains formulas that pull data from the sales figures on the first and second worksheets.
You want to view all three worksheets simultaneously so you can see how the totals on the third worksheet are affected by changes to the figures in the first two worksheets. You currently have the workbook open in Excel.
Which combination of the following steps would enable you to view all three worksheets side-byside? Choose two.
正解：C、D
解答を投票する
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
解答を投票する