PrepAway - Latest Free Exam Questions & Answers

Category: 77-882

Exam 77-882: Excel 2010

Which of the following conditional formulas will you insert to accomplish the task?

You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team using
Microsoft Excel. You want the report to appear in the following format:

You want the Remark column to be filled through a conditional formula. The criteria to give the
remark is as follows:
If the sales of the First Quarter is greater than or equal to 1200, display “Well Done”
If the sales of the First Quarter is lesser than 1200, display “Improve in Next Quarter”
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:

Which of the following conditional formulas will you insert to accomplish the task?

Which of the following steps will you choose to accomplish the task involving the least amount of administrati

You are creating a business report by using Microsoft Excel 2010. You have arranged sales data as shown below:

You want to provide pictorial representation of the trend of these sales data in front of each row.
Which of the following steps will you choose to accomplish the task involving the least amount of
administrative burden?

Which of the following formulas will provide the required result?

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?

Mark the option that you will choose to accomplish the task.

You work as an Office Assistant for Media Perfect Inc. Your responsibility includes creating sales
reports for the Sales department. You use Microsoft Excel 2010 to create these reports. You have
created an yearly sales report. The fragment of the report is shown below:

As the report is quite wide, printing this report involves three A4 size pages. You want the first
column (column A) to repeat in every printed page. Mark the option that you will choose to
accomplish the task.


Page 1 of 612345...Last »