QUESTION NO: 1
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2013.
Your workbook includes several worksheets as shown in the image given below:
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2013.
Your workbook includes several worksheets as shown in the image given below:
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?
Correct Answer: A
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 2
You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You want to return the price per $100 face value of a security that pays interest at maturity. Which of the following financial functions will you use to accomplish the task?
You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You want to return the price per $100 face value of a security that pays interest at maturity. Which of the following financial functions will you use to accomplish the task?
Correct Answer: C
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 3
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly 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 required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly 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 required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: A,C,D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 4
Which of the following can be defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter?
Which of the following can be defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter?
Correct Answer: D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 5
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel
2013. Rick wants to trace the project with the actual requirements. For this purpose, he is
required to compare month to month, actual v budget, quarter to quarter, year to year variances.
Which of the following will Rick use to accomplish the task?
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel
2013. Rick wants to trace the project with the actual requirements. For this purpose, he is
required to compare month to month, actual v budget, quarter to quarter, year to year variances.
Which of the following will Rick use to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 6
DRAG DROP
You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front
of their descriptions.
DRAG DROP
You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front
of their descriptions.
Correct Answer:
QUESTION NO: 7
HOTSPOT
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.
HOTSPOT
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.
Correct Answer:
