77-882 試験問題を無料オンラインアクセス

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?

• A.Use the Select All Sheets function. Click one of the sheets and enter the value into cell B2.
• B.Use the Select All Sheets function and enter the value into cell B2 on the active sheet.
• C.Configure a 3-D Cell Reference then enter the value into cell B2 on the first sheet.
• D.Enter the value into cell B2 on the first sheet then use Copy and Paste to paste the value into the other sheets.

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.

• A.Use the Save As function to save two more copies of the workbook with different names.
• B.Use the File tab > Open function to open two more copies of the workbook.
• C.Use the Arrange All > Arrange Vertical function to display all three copies of the workbook side-by-side.
• D.Navigate to the View tab and use the New Window function to open two more copies of the workbook.
• E.Resize the Excel windows to display all three copies of the workbook side-by-side.
• F.Open two more copies of Excel 2010 and open two more copies of the workbook.

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 need to restrict the type of information that users can enter into the workbook. You want to ensure that customer's names are spelt correctly by using a list for users to select from and you want to limit the cells that users can enter numbers into. You also want users to be presented with a message when they enter invalid data.
Which function of Excel should you use?

• A.You should use the Format function on the Home tab.
• B.You should use the Protect Workbook function on the Review tab.
• C.You should use the Data Validation function on the Data tab.
• D.You should use the Data Consolidation function on the Data tab.

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?

• A.You should consider inserting Line Charts.
• B.You should consider inserting Sparklines.
• C.You should consider inserting Shapes.
• D.You should consider inserting an image.

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?

• A.An Area chart.
• B.A half Bar chart.
• C.A Full Pie chart.
• D.A Line doted chart.