Microsoft Excel 2010 - 77-882 FREE EXAM DUMPS QUESTIONS & ANSWERS
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated.
Which Excel function should you make use of in your spreadsheet?
You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated.
Which Excel function should you make use of in your spreadsheet?
Correct Answer: C
Vote an answer
You work as a Sales Manager for Blue Well Inc. You have to create a report in Excel 2010 in the
following format:
What is the most likely cause?
following format:
What is the most likely cause?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is
creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used
many formulas in her report. She wants to monitor a cell which contains a formul a. The formula
refers to many other cells that are located in different worksheets in the report. She wants to know
the effects on the cell when the values in different sheets changes. She requests you to help her out
to accomplish the task. Which of the following steps will you advice her to accomplish the task?
creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used
many formulas in her report. She wants to monitor a cell which contains a formul a. The formula
refers to many other cells that are located in different worksheets in the report. She wants to know
the effects on the cell when the values in different sheets changes. She requests you to help her out
to accomplish the task. Which of the following steps will you advice her to accomplish the task?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as the Finance Manager at ABC.com. It is the end of the financial year and you are auditing the accounts for the last year. You have imported the records from last year's company bank statements into a Microsoft Office Excel 2010 workbook.
You want to list all payments to a partner company named Weyland Industries with the category name of Services.
How can you configure the workbook to display only the records that contain Weyland Industries and Services?
You want to list all payments to a partner company named Weyland Industries with the category name of Services.
How can you configure the workbook to display only the records that contain Weyland Industries and Services?
Correct Answer: A
Vote an answer
You work as a Help Desk Technician for Tech Perfect Inc. Rick, a Sales Manager, uses Microsoft
Excel 2010 to prepare sales reports. He is creating a sales report in which he wants to compare the
relative magnitude of the targets achieved by his sales team members as shown in the image given
below:
He wants your help in formatting the table in the required way. Choose the required steps to
accomplish the task.
Excel 2010 to prepare sales reports. He is creating a sales report in which he wants to compare the
relative magnitude of the targets achieved by his sales team members as shown in the image given
below:
He wants your help in formatting the table in the required way. Choose the required steps to
accomplish the task.
Correct Answer:
Explanation:
In order to accomplish the task, Rick should take the following steps:
Select the range for which the display of relative magnitude is required.
Select the Data Bars option through Home tab > Styles Group > Conditional Formatting.
The Conditional Formatting feature of Excel provides a facility to compare the relative magnitude
of values in a cell range by applying colors. According to the image shown in the question, relative
magnitude of values in a cell range is displayed by extending a band of color across the cell.
Hence, you should ask Rick to use the Data Bars option of the Conditional Formatting feature. The
Color Scales option of the Conditional Formatting feature compares the relative magnitude of
values in a cell range by applying colors from a two-or three-color set to the cells. Using this
option the same table will appear as follows:
The Format as Table option is used to configure the whole table in a certain style. It does not
provide the facility to compare values in a range of cells.
Reference:
Microsoft Excel Help, Contents: "Add, change, or clear conditional formats"
You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales
incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a
worksheet for preparing the report. You have inserted the sales figures of all sales managers as
shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total
first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to
the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8
cell. Which of the following formulas will you insert to accomplish the task?
incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a
worksheet for preparing the report. You have inserted the sales figures of all sales managers as
shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total
first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to
the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8
cell. Which of the following formulas will you insert to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
You want to print copies of the report to distribute to other employees in a meeting. The report uses several columns. You view the printable area of the worksheet and see that the columns do not fit on a single page.
To be able to print all the columns on a single page without scaling down the page, you want to change the layout of the worksheet from portrait to landscape.
How can you change the layout to landscape?
You want to print copies of the report to distribute to other employees in a meeting. The report uses several columns. You view the printable area of the worksheet and see that the columns do not fit on a single page.
To be able to print all the columns on a single page without scaling down the page, you want to change the layout of the worksheet from portrait to landscape.
How can you change the layout to landscape?
Correct Answer: A
Vote an answer
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
Some of the cells in a worksheet are formatted using the Heading1 style and some are formatted using the Heading2 style. You select one of the cells formatted with the Heading1 style and press the Delete button on the keyboard.
When you enter some new text into the cell, you discover that the new text is formatted with the Heading1 style. You want to delete the text and the formatting from all the cells formatted with the Heading1 or Heading2 styles.
You select all the formatted cells and select the Clear icon in the Editing group on the Home tab. Which option should you select to delete the formatting and the contents of the selected cells?
Some of the cells in a worksheet are formatted using the Heading1 style and some are formatted using the Heading2 style. You select one of the cells formatted with the Heading1 style and press the Delete button on the keyboard.
When you enter some new text into the cell, you discover that the new text is formatted with the Heading1 style. You want to delete the text and the formatting from all the cells formatted with the Heading1 or Heading2 styles.
You select all the formatted cells and select the Clear icon in the Editing group on the Home tab. Which option should you select to delete the formatting and the contents of the selected cells?
Correct Answer: C
Vote an answer
You work as an Office Assistant at ABC.com. You are using Microsoft Office Excel 2010 to create a workbook.
You want the worksheet tabs to appear in colors as shown below.
How do you change the color of worksheet tabs?
You want the worksheet tabs to appear in colors as shown below.
How do you change the color of worksheet tabs?
Correct Answer: A
Vote an answer