Online Access Free 77-427 Exam Questions

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 2013. 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.Accounting template
• C.Form control
• D.Gantt Chart Template

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
  you
  want to create a slicer.
• B.Hold down CTRL, and then click the items on which you want to filter.
• C.Click anywhere in the PivotTable report for which you want to create a slicer.
• D.Click Insert Slicer in the Sort & Filter group on the Options tab.
• E.Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick has to perform the following tasks:
Summarize large amounts of data. Analyze numeric data.
Answer unexpected questions about data.
Which of the following actions will Rick take to accomplish the task?

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

HOTSPOT
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2013 application on the network. You open the application and see various changes in Excel 2013. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.

Correct Answer:

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2013 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

• A.Select all the text of the document.
  Change font style to Verdana and font color to light gray. Use vibrant colors for charts.
• B.Choose one of the pre-built themes.
• C.Use the SmartArt option.
• D.Create a new workbook through a template. Copy all data and charts of the report to the new workbook.