Microsoft Excel 2010 Expert (77-888) Free Practice Test
Question 1
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 2
HOTSPOT
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open the application and see various changes in Excel 2010. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open the application and see various changes in Excel 2010. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.
Correct Answer:
Question 3
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 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?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 4
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 summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. 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.
Microsoft Excel 2010. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. 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: A,B,D,E
Question 5
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.
Which of the following options will you choose to accomplish the task?
Which of the following options will you choose to accomplish the task?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 6
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick is creating a project through Microsoft Excel 2010. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?
Rick is creating a project through Microsoft Excel 2010. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 7
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2010. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will Rick use to accomplish the task?
Excel 2010. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will Rick use to accomplish the task?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).