77-427 Microsoft Excel 2013 Expert Part 1 - Practice Questions

Question 4

You work as a Project Manager for Blue Well Inc. The company has a Windows-based network. You want to rename a worksheet as Important.

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.

Select all that apply, then click Submit answer.

○
Click the Insert tab and open the name sheet.
○
Enter the name and click the OK button.
○
Right-click on the Sheet tab and select the Rename option.
○
Delete the old name, type the new name, and then click OK.

Question 5

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.

Select all that apply, then click Submit answer.

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

Reference / correct answer:

The maxoccurs attribute is not equal to 1.

The relationship of the mapped element with other elements is not preserved.

The various issues with exporting XML data are as follows:

1. MAP CAN BE EXPORTED BUT SOME REQUIRED ELEMENTS ARE NOT MAPPED: Thiserror occurs under the following situations:

The XML map associated with this XML table contains one or more required elements that are not mapped to the XML table. The element is a recursive structure.

The XML table contains a variety of mixed content.

2. EXCEL CANNOT SAVE THE WORKBOOK BECAUSE IT DOES NOT CONTAIN ANY XML

MAPPINGS: Excel cannot save the user's workbook in the XML Data file unless one or more mapped ranges are created.

3. XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE: An XML mapping cannot be

exported if the relationship of the mapped element with other elements is not preserved due to the following reasons:

The mapped element's schema definition is contained within a sequence with the following attributes:

The maxoccurs attribute is not equal to 1.

The sequence has more than one direct child element defined or has an extra compositor as a direct child. Nonrepeating sibling elements with the same repeating parent element are mapped to dissimilar XML tables. Various repeating elements are mapped to the same XML table and the recurrence is not defined by an ancestor element. Child elements from various parents are mapped to the same XML table. XML schema constructs a list of lists, denormalized data, or a choice construct.

References: https://support.office.com/en-us/article/issue-verifying-an-xml-map-for-exportfbfcdb77-c2d6-4040-b256-e584a71151b0

Question 6

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to delete the slicer.

Which of the following steps can you take to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

Select all that apply, then click Submit answer.

○
Click the slicer that you want to delete on the Options tab in the Slicer type group.
○
Click the Macro setting, and then delete the slicer from the Macro-enabled slicers list.
○
Click the slicer, and then press Delete.
○
Right-click the slicer, and then click Remove .

77-427 – Microsoft Excel 2013 Expert Part 1