Microsoft Excel 2013 Expert Part One - 077-427 Exam Practice Test
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.
Each correct answer represents a part of the solution. Choose all that apply.
Correct Answer: A,B
Vote an answer
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through
Microsoft Excel 2013. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
Microsoft Excel 2013. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
Correct Answer: A,C,D,E
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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.
Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: C,D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining financial budget and other financial calculations. You want to return the depreciation of an asset for a specified period by using the fixed-declining balance method and to return the future value of a starting principal after applying a series of compound interest rates.
Which of the following financial functions will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
Which of the following financial functions will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: B,D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.
answer represents a part of the solution. Choose all that apply.
Correct Answer: A,B,C,D,F
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team
Using Microsoft Excel. You want the report to appear in the following format: You want the Remark column to be filled through a conditional formula. The criteria to give the
remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the
sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?
Using Microsoft Excel. You want the report to appear in the following format: You want the Remark column to be filled through a conditional formula. The criteria to give the
remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the
sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).