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

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You want to change values in cells to observe the way in which those changes are affecting the outcome of formulas in the worksheet. Which of the following will you use to accomplish the task?

• A.What-if analysis
• B.Trust Center
• C.Accounting template
• D.Form control

Which of the following can be defined as easy-to-use filtering components containing a set
of buttons that enable users to quickly filter data in a PivotTable report, without opening
drop-down lists to find the items to filter?

• A.Accounting templates
• B.ActiveX controls
• C.Slicers
• D.Form controls

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick is creating a project through Microsoft Excel 2010. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?

• A.Trust Center
• B.Gantt Chart Template
• C.Accounting template
• D.Form control

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

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

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 2010. 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.Use stand-alone slicers.
• B.Create sparklines.
• C.Create a PivotTable report.
• D.Configure form controls.