Microsoft Excel 2010 Expert - 77-888 Exam Practice Test
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 2010. You have arranged sales data as shown below:
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2010. You want to export XMLdata to your Excel 2010 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.
Microsoft Excel 2010. You want to export XMLdata to your Excel 2010 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.
Correct Answer: A,B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You work as a Project Manager for Blue Well Inc. The company has a Windows-based network. You want to rename a worksheet as Important.
Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.
Correct Answer: C,D
Vote an answer
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You are creating a hot spot on a graphic that other users can click to run a macro. Which of the following steps will you take 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,C,D,E,F,G,H
Vote an answer
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010. The report worksheet will include the sales made by all the sales managers in the month of January.
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?
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test 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 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?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for creating various types of reports. You have created a report in the format given below:
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?
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?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).