Microsoft 77-427 - Microsoft Excel 2013 Expert Part 1 Exam
Page: 1 / 13
Total 62 questions
Question #1 (Topic: )
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based
network. You have changed some data in the worksheet of the company. You are
submitting the sell workbook of the company to the Administrator of the company for
comments. Now, you want to merge input that you receive into a copy of that workbook,
including the changes and comments that you want to keep. For this purpose, it is required
to access and use the stored change history. Which of the following will you use to
accomplish the task?
network. You have changed some data in the worksheet of the company. You are
submitting the sell workbook of the company to the Administrator of the company for
comments. Now, you want to merge input that you receive into a copy of that workbook,
including the changes and comments that you want to keep. For this purpose, it is required
to access and use the stored change history. Which of the following will you use to
accomplish the task?
A. Slicer-enabled highlighting
B. Onscreen highlighting
C. Reviewing of changes
D. History tracking
Answer: C
Question #2 (Topic: )
You work as an Office Assistant for Blue well Inc. The company has a Windows-based
network. You want to create a VBA procedure for the open event of a workbook. You are
required to set the security level temporarily for enabling all macros. Mark the option that
you will choose first to accomplish the task.
[Microsoft-77-427-3.0/Microsoft-77-427-2_2.png]
network. You want to create a VBA procedure for the open event of a workbook. You are
required to set the security level temporarily for enabling all macros. Mark the option that
you will choose first to accomplish the task.
[Microsoft-77-427-3.0/Microsoft-77-427-2_2.png]
Answer: [Microsoft-77-427-3.0/Microsoft-77-427-3_2.png]
Question #3 (Topic: )
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?
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 use stand-alone slicers.
C. He will create a PivotTable report.
D. He will configure form controls.
Answer: C
Question #4 (Topic: )
You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet
of the
company's high selling products. You want to find out the matching values. You get an
unexpected error that when you attempt to look up or match a lookup_value within an
array, Excel is not able to recognize the matching value. Which of the following steps will
you take to resolve the problem? Each correct answer represents a part of the solution.
Choose all that apply.
of the
company's high selling products. You want to find out the matching values. You get an
unexpected error that when you attempt to look up or match a lookup_value within an
array, Excel is not able to recognize the matching value. Which of the following steps will
you take to resolve the problem? Each correct answer represents a part of the solution.
Choose all that apply.
A. Remove the unseen spaces at the start or end of the first Macro cell.
B. Delete the column having the TRIM function.
C. Copy the contents of the new column and paste them on the top of the original column by using paste > special > values sequence.
D. Create a new column subsequent to the one with the additional spaces in it.
E. Use the TRIM function in the new column.
Answer: B,C,D,E
Question #5 (Topic: )
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2013
for creating various types of reports. You have created a report in the format given below:
[Microsoft-77-427-3.0/Microsoft-77-427-5_2.png]
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell.
Which of the following formulas will provide the required result?
for creating various types of reports. You have created a report in the format given below:
[Microsoft-77-427-3.0/Microsoft-77-427-5_2.png]
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell.
Which of the following formulas will provide the required result?
A. COUNTIF(B2:C5,"=Yes")
B. COUNTIFS(B2:C5,"=Yes")
C. COUNTIF(B2:B5,"=Yes",C2:C5,"=Yes")
D. COUNTIFS(B2:B5,"=Yes",C2:C5,"=Yes")
Answer: D
