You work as a Sales Manager for Maini Industries. Your company manufactures and sells
construction equipment. You have to create a report that will show the highest selling items of each
month. The report will be in the following format:

In a workbook, you create a table named Item_table as shown below:

You fill in the required entries in the workbook.

For the third column of the sheet, you want to use formulas to fill in the values. You want the cells in
the third column to get automatically filled with the names corresponding to ItemID in the second
column. You want the exact values to be filled in the column. You select the C2 cell in the third column.
Which of the following formulas will you enter in order to accomplish the task?

You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel
2010. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flowchart symbols in the report.

Sarah works as an Office Assistant for Perfect Wear Inc. She has created a sales report in a
worksheet using Microsoft Excel 2010. She has inserted a chart to summarize data visually. She
wants to print a chart without printing the rest of the accompanying worksheet. Choose the required
steps that Sarah will take to accomplish the task.

You work as an Office Assistant for Pecuniary Inc. You are creating a report in a workbook in
Microsoft Excel. The company borrowed a sum of $1000000 at 6% interest rate, which is to be paid
within 24 months. You are required to prepare a report in a workbook in Microsoft Excel, which
shows the calculation of monthly installments to be paid to repay the loan. Which of the following
formulas will you use to accomplish the task?

You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales
reports of the company. You create a report in a workbook in Excel 2010. A worksheet in the report
contains a list. The fragment of the sheet is shown below:

The list contains the sales data of all sales managers of the company. You want to format all the cells
that contain the value “Mark” in the Sales Manager column, so that they appear differently. You
have to do it with the least administrative burden. Choose the required steps that you will take to accomplish the task.