Microsoft 77-427 - Microsoft Excel 2013 Expert Part 1 Exam
Page: 3 / 13
Total 62 questions
Question #11 (Topic: )
Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2013.
He has entered data in five worksheets in a workbook. He wants to enter a disclaimer
message in the A1 cell of each sheet in the workbook as shown in the image given below:
[Microsoft-77-427-3.0/Microsoft-77-427-14_2.png]
Which of the following is the easiest way to accomplish the task?
He has entered data in five worksheets in a workbook. He wants to enter a disclaimer
message in the A1 cell of each sheet in the workbook as shown in the image given below:
[Microsoft-77-427-3.0/Microsoft-77-427-14_2.png]
Which of the following is the easiest way to accomplish the task?
A. Write a disclaimer message in the A1 cell of the first sheet. Copy the disclaimer message and paste it on the remaining sheets.
B. Write a disclaimer message in the A1 cell of the first sheet. In the other sheets, insert a formula that points to the A1 cell of the first worksheet.
C. Select all the five sheets. Click the first sheet. Write a disclaimer message in the A1 cell of the active sheet.
D. Select all the five sheets. Write a disclaimer message in the A1 cell of the active sheet.
Answer: D
Question #12 (Topic: )
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 disconnect the slicer. You have clicked anywhere in the PivotTable
report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
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 disconnect the slicer. You have clicked anywhere in the PivotTable
report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
A. Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
B. Right-click the slicer, and then click Remove <Name of slicer>.
C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
D. Click the slicer, and then press Delete.
Answer: A,C
Question #13 (Topic: )
You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet
in Excel 2013. You want to insert flow-chart in the sheet. Mark the option that you will
in Excel 2013. You want to insert flow-chart in the sheet. Mark the option that you will
Answer: A,C
Question #14 (Topic: )
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.
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 maxoccurs attribute is not equal to 1.
B. The relationship of the mapped element with other elements is not preserved.
C. The element is a recursive structure.
D. The XML map associated with this XML table contains one or more required elements that are not mapped to the XML table.
Answer: A,B
Question #15 (Topic: )
You work as an Office Assistant for Media Perfect Inc. You are creating a report in
Microsoft Excel 2013. The report worksheet will include the sales made by all the sales
managers in the month of January.
[Microsoft-77-427-3.0/Microsoft-77-427-19_2.png]
In the worksheet, you are required to place a pictorial representation displaying the
percentage of
total sales made by each sales manager in January. Which of the following charts will you
use to
accomplish the task?
Microsoft Excel 2013. The report worksheet will include the sales made by all the sales
managers in the month of January.
[Microsoft-77-427-3.0/Microsoft-77-427-19_2.png]
In the worksheet, you are required to place a pictorial representation displaying the
percentage of
total sales made by each sales manager in January. Which of the following charts will you
use to
accomplish the task?
A. Bar
B. Line
C. Column
D. Pie
Answer: D
