Online Access Free 77-427 Exam Questions

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2013. You want to export XMLdata to your Excel 2013 worksheet. On exporting the XML data, the following error message appears:
"XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE"
Which of the following are the reasons that are causing the above error? Each correct answer
represents a complete solution. Choose all that apply.

• A.The relationship of the mapped element with other elements is not preserved.
• B.The XML map associated with this XML table contains one or more required elements that are not mapped to the XML table.
• C.The maxoccurs attribute is not equal to 1.
• D.The element is a recursive structure.

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 create the accounting template.
• B.He will configure form controls.
• C.He will create a PivotTable report.
• D.He will use stand-alone slicers.

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2013. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will
Rick use to accomplish the task?

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

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.Trust Center
• B.Accounting template
• C.What-if analysis
• 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 Current Sheet
• B.Encrypt with Password
• C.Protect Workbook Structure
• D.Mark as Final