Microsoft Excel 2010 - 77-882 Exam Practice Test
Martha works as an Office Executive for Tech Profile Inc. She uses Microsoft Excel 2010 to create
office reports. She often needs to fill names of all employees in each department of the company in
her reports. Which of the following steps should she take to ease her task?
office reports. She often needs to fill names of all employees in each department of the company in
her reports. Which of the following steps should she take to ease her task?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Sarah works as an Office Assistant for Perfect Wear Inc. She has created a sales report in a
worksheet using Microsoft Excel 2010. She has inserted a chart to summarize data visually. She
wants to print a chart without printing the rest of the accompanying worksheet. Choose the
required steps that Sarah will take to accomplish the task. Select an item from the right pane. Click
button to move the selected item to the left pane. Click button to move the item back to the right
pane. Click and buttons to sort the list, if required.
worksheet using Microsoft Excel 2010. She has inserted a chart to summarize data visually. She
wants to print a chart without printing the rest of the accompanying worksheet. Choose the
required steps that Sarah will take to accomplish the task. Select an item from the right pane. Click
button to move the selected item to the left pane. Click button to move the item back to the right
pane. Click and buttons to sort the list, if required.
Correct Answer:
Explanation:
In order to accomplish the task, Sarah will have to take the following steps:
Select the chart.
Click the File button and select the Print option. Click the Print button.
When a user first selects the chart and then gives the print command, Excel adds and selects the
Selected Chart option in Settings. This is the only option that is enabled.
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a document. The document will be sent to other users in the Sales department when completed.
The Excel workbook contains three tabs with data on each tab. The tabs are named Sheet1, Sheet2 and Sheet3.
While working on Sheet1, you navigate to the Review tab and click the Protect Sheet button. You leave the default options, enter a password and click ok.
What effect will this have on the workbook?
The Excel workbook contains three tabs with data on each tab. The tabs are named Sheet1, Sheet2 and Sheet3.
While working on Sheet1, you navigate to the Review tab and click the Protect Sheet button. You leave the default options, enter a password and click ok.
What effect will this have on the workbook?
Correct Answer: C
Vote an answer
You have created a sales report in Microsoft Excel 2010 as shown in the image below:
You need to sort the data in such a way that sales data for the year 2010 is listed in higher to lower
order. Which of the following steps will you take to accomplish the task?
You need to sort the data in such a way that sales data for the year 2010 is listed in higher to lower
order. Which of the following steps will you take to accomplish the task?
Correct Answer:
Explanation:
According to the question, you need to sort the data in such a way that sales data for the year 2010
is listed in higher to lower order. Take the following steps in order to accomplish the task:
1. Select a cell in the data range.
2. Click the Sort option in Data tab.
3. Select My Data Has Header check-box.
4. Select 2010 in the Sort By option.
5. Select Value in the Sort On column.
6. Select Largest to Smallest option in Order column.
Sally works as an Accounts Administrator at ABC.com. She is using Microsoft Office Excel 2010 to edit a workbook.
The workbook contains four worksheets as shown below.
Sally selects all four worksheets as shown below.
Sally wants to cancel the selection so she clicks on one of the worksheets. However, the four worksheets remain selected.
Sally calls you and asks how to cancel the selection.
Which two of the following options could you advise Sally to do? Choose two. Each answer represents a complete solution.
The workbook contains four worksheets as shown below.
Sally selects all four worksheets as shown below.
Sally wants to cancel the selection so she clicks on one of the worksheets. However, the four worksheets remain selected.
Sally calls you and asks how to cancel the selection.
Which two of the following options could you advise Sally to do? Choose two. Each answer represents a complete solution.
Correct Answer: B,C
Vote an answer
You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to edit a workbook.
The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month.
You want to enter a value in the cell B2 on each worksheet.
What is the easiest way to insert the same value into the same cell on all worksheets in a workbook?
The workbook has twelve worksheets. The worksheets are named January through December and have rows labeled according to each day of the month.
You want to enter a value in the cell B2 on each worksheet.
What is the easiest way to insert the same value into the same cell on all worksheets in a workbook?
Correct Answer: A
Vote an answer
Martha works as an Office Assistant for Tech Perfect Inc. She uses Microsoft Excel 2010 for
working on a report. She wants to add a picture as a background in her Excel worksheet. She does
not want that picture to be printed while printing. Which of the following steps will she take to
accomplish the task?
working on a report. She wants to add a picture as a background in her Excel worksheet. She does
not want that picture to be printed while printing. Which of the following steps will she take 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 have upgraded your Excel 2007 to Excel 2010. You want to personalize your Excel
environment through the Excel Options window given below:
You are unable to find the Office button. Choose the steps you will take to accomplish the task.
environment through the Excel Options window given below:
You are unable to find the Office button. Choose the steps you will take to accomplish the task.
Correct Answer:
Explanation:
In order to accomplish the task, you will have to take the following steps:
Click on the File menu.
Click Option to open the Excel Option window.
A major change in Office 2010 from Office 2007 is elimination of the Office button. Instead, it
incorporates a Backstage View for personalizing the office environment. Backstage View can be
evoked by clicking the File menu button.
Reference:
Changes in Excel 2010
You work as a Sales Assistant at ABC.com. All users in the Sales department run Microsoft Office 2010.
You currently have Excel 2010 open and are working on a new workbook. You want to open an existing workbook that is saved in your Documents folder.
Which two of the following methods could you use to open an existing workbook? Choose two.
You currently have Excel 2010 open and are working on a new workbook. You want to open an existing workbook that is saved in your Documents folder.
Which two of the following methods could you use to open an existing workbook? Choose two.
Correct Answer: C,D
Vote an answer