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 views will you have to work on?
You work as a Sales Manager for Net World Inc. You are creating a sales report in Microsoft Excel
2010. You want to create the report while keeping an eye on how it will look in printed format.
Which of the following views will you have to work on?
She wants to monitor a cell which contains a formul
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
Which of the following steps will she take to accomplish the task?
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?
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?
Which of the following steps will you take to accomplish the task with least administrative effort?
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. You have
selected all worksheets available in the workbook as shown below:
Now, you want to cancel the selection. Which of the following steps will you take to accomplish the
task with least administrative effort?
Mark the option that he will choose to accomplish the task.
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.
Which of the following actions will be performed by the formula?
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?