Microsoft 77-427 - Microsoft Excel 2013 Expert Part 1 Exam
Page: 2 / 13
Total 62 questions
Question #6 (Topic: )
You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based
network. You are creating a business report by using. Microsoft Excel 2013. You have
arranged sales data as shown below:
[Microsoft-77-427-3.0/Microsoft-77-427-7_2.png]
You want to provide pictorial representation of the trend of the sales data in front of each
row.
Which of the following actions will you take to accomplish the task with the least amount of
administrative burden?
network. You are creating a business report by using. Microsoft Excel 2013. You have
arranged sales data as shown below:
[Microsoft-77-427-3.0/Microsoft-77-427-7_2.png]
You want to provide pictorial representation of the trend of the sales data in front of each
row.
Which of the following actions will you take to accomplish the task with the least amount of
administrative burden?
A. Use stand-alone slicers.
B. Configure form controls.
C. Create sparklines.
D. Create a PivotTable report.
Answer: C
Question #7 (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 are trying to intersect two ranges that do not intersect
each
other. Which of the following errors will be occurred in this situation?
of the
company's high selling products. You are trying to intersect two ranges that do not intersect
each
other. Which of the following errors will be occurred in this situation?
A. #VALUE!
B. #NAME?
C. #NULL!
D. #DIV/0!
Answer: C
Question #8 (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 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.
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.
A. Click the slicer that you want to delete on the Options tab in the Slicer type group.
B. Click the Macro setting, and then delete the slicer from the Macro-enabled slicers list.
C. Click the slicer, and then press Delete.
D. Right-click the slicer, and then click Remove <Name of slicer>.
Answer: C,D
Question #9 (Topic: )
Which of the following is used to display a trend based on adjacent data in a clear and
compact
graphical representation by taking up a small amount of space?
compact
graphical representation by taking up a small amount of space?
A. Trendline
B. Line chart
C. Sparkline
D. Backstage view
Answer: C
Question #10 (Topic: )
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 select the Encrypt
with Password option as a protection measure for the document you are sharing. Now, you
have to specify a password in the Password box in the Encrypt Document dialog box
appeared for editing the document. But you have forgotten the password. What will happen
in this situation?
Excel 2013 and shared it with the other employees of the company. You select the Encrypt
with Password option as a protection measure for the document you are sharing. Now, you
have to specify a password in the Password box in the Encrypt Document dialog box
appeared for editing the document. But you have forgotten the password. What will happen
in this situation?
A. You will use a new password.
B. You will ask Microsoft to retrieve the password.
C. You will fetch the password from the list in which you have saved it.
D. You will create a new document.
Answer: C
