Online Access Free 77-882 Exam Questions

Alan works as a Sales Manager for MVP Technologies. He is creating a sales report in Microsoft
Excel 2010. In the report, he needs to enter the names of sales executives in one column and the
sales target (in dollars) achieved by them in the next column as shown in the image below:

He wants to ensure that the color of a cell changes automatically to orange when the sales figure
entered in the cell is more than $10,000. Which of the following actions will he take to accomplish
the task?

• A.Use the conditional formatting feature.
• B.Use the AutoFormat feature.
• C.Use a style.
• D.Use the AutoCorrect feature.

You work as the Financial Controller at an engineering company. The company is considering taking out a loan to purchase some new machinery.
You are in the process of evaluating the payment options for different loan amounts over different repayment periods. You are using Microsoft Office Excel 2010 to calculate the repayments.
Assuming a constant interest rate and constant monthly payments, which Excel function would you use to calculate the loan repayments?

• A.LOAN()
• B.RATE()
• C.PV()
• D.PMT()

You work in the office at ABC.com. Your computer has just been uABCraded from Microsoft Office 2007 to Microsoft Office 2010.
You create a workbook using Microsoft Office Excel 2010. Microsoft Office 2010 has a new feature called the Backstage View. The Backstage View gives you access to functions that affect the workbook as a whole and to settings that affect the application itself.
How do you get to the Backstage View?

• A.By selecting the Custom Views option on the View tab.
• B.By clicking the File tab.
• C.By clicking the Office Button on sheet.
• D.By clicking the Page Layout tab.

You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales report.
The report contains the table shown below.

You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?

• A.A half Bar chart.
• B.A Line doted chart.
• C.A Full Pie chart.
• D.An Area chart.

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?

• A.You should make use of the TIMEVALUE() function.
• B.You should make use of the DATEVALUE() function.
• C.You should make use of the TIME() function.
• D.You should make use of the NOW() function.