Free Microsoft 77-882 Practice Test & Real Exam Questions

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You
have inserted the following formula in a cell: VLOOKUP(12, A2:C10, 3, FALSE ) Which of the
following actions will be performed by the formula?

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?

You work as a Sales Manager for Peach Tree Inc. Your responsibility includes creating sales
reports of the company. You create a report in a workbook in Excel 2010. The report contains a
worksheet that has been formatted by using the conditional formatting feature. You have specified
five conditions for conditional formatting of a list appearing in the sheet. You save the report and
send it to your manager. He informs you that the sheet on which conditional formatting feature is
applied is not appearing according to his requirement. He further specifies that only a few of the
conditions are applying. What is the most likely cause?

Your work at ABC.com includes the preparation of company spreadsheets using Microsoft Office Excel 2010.
You are preparing a financial report that will be emailed to company managers. You want to add a background image of the company logo to the spreadsheet. The background image should not be printed if a manager decides to print a copy of the spreadsheet.
How should you configure the spreadsheet?

You work in the Sales office at ABC.com. You are using Microsoft Office Excel 2010 to prepare a financial report.
The report is a complicated analysis of the company financial performance over the last year and projected growth for the next year based on the figures. The report will be sent to ABC.com board members.
You have used subtotals throughout the report to make it easier for you to verify the accuracy of the figures. After completing the report and verifying the totals, you want to remove the subtotals before you send the report to the board members.
Which combination of the following steps describes how to remove the subtotals from a worksheet? Choose two.

You work in the Sales office at Weyland Industries. You are using Microsoft Office Excel 2010 to prepare a financial report. The report will be sent to managers at a partner company named ABC.com.
ABC.com users use various versions of Microsoft Office including Microsoft Office 2003, 2007 and 2010.
You need to ensure that your financial report can be viewed You should consider the managers at ABC.com irrespective of which version of Microsoft Office they are using.
How can you ensure that the Excel features used in your spreadsheet are compatible with previous versions of Excel?

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?

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 work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report
of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created
a quarterly sales report of the department. After entering required data and inserting charts, you
want to give a professional look to the document. You want to produce the document with
soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to
accomplish the task with least administrative burden?