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

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?

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

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to get the trend of the Business data range. For this purpose, you want to use trendlines in the chart. Which of the following steps will you take to apply the trendlines in the chart?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Select the type that you want from Trendline options.
• B.Clear the check box of any Trendline fields to disconnect a slicer.
• C.Select a chart and then navigate to the Chart Tools Layout tab.
• D.Click the Insert Trendline arrow, and then click Trendline Connections on the Options tab in the Sort & Filter group.

Which of the following is used to display a trend based on adjacent data in a clear and compact
graphical representation by taking up a small amount of space?

• A.Backstage view
• B.Trendline
• C.Sparkline
• D.Line chart

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.Evaluate Formula
• B.Accounting template
• C.Trust Center
• D.Form control

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.
Which of the following options will you choose to accomplish the task?

• A.Protect Workbook Structure
• B.Protect Current Sheet
• C.Encrypt with Password
• D.Mark as Final