077-427 무료 덤프문제 온라인 액세스

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You have changed some data in the worksheet of the company. You are submitting the sell workbook of the company to the Administrator of the company for comments. Now, you want to merge input that you receive into a copy of that workbook, including the changes and comments that you want to keep. For this purpose, it is required to access and use the stored change history. Which of the following will you use to accomplish the task?

• A.Onscreen highlighting
• B.History tracking
• C.Slicer-enabled highlighting
• D.Reviewing of changes

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2013. 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?

• A.Bar
• B.Column
• C.Line
• D.Pie

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel
2013. Rick wants to trace the project with the actual requirements. For this purpose, he is
required to compare month to month, actual v budget, quarter to quarter, year to year variances.
Which of the following will Rick use to accomplish the task?

• A.Form control
• B.Trust Center
• C.Accounting template
• D.Evaluate Formula

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?

• A.He will create a PivotTable report.
• B.He will use stand-alone slicers.
• C.He will create a PivotChart report.
• D.He will configure form controls.

You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2013. You have arranged sales data as shown below:

You want to provide pictorial representation of the trend of the sales data in front of each row.
Which of the following actions will you take to accomplish the task with the least amount of
administrative burden?

• A.Configure form controls.
• B.Use stand-alone slicers.
• C.Create sparklines.
• D.Create a PivotTable report.