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 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.

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 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.

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 are creating business report through Microsoft Office 2010. You want to add trend lines for each
row as shown in the image below:

Choose the correct steps to accomplish the task.

You work as an Office Assistant of Mark World Inc. You have created a report in a workbook in Excel
2010. You want to change the layout of the worksheet from portrait to landscape. Mark the option
that you will choose to accomplish the task.

You work as an Office Assistant for Tech Perfect Inc. You are creating a report in a workbook in Excel
2010. Before creating a final report, you are required to test some logical conditions. You enter test
data in a worksheet in the report. The fragment of the sheet is shown below:

You are testing logical conditions to use them in your report later. Which of the following conditional
formulas will return “True”?

You work as an office assistant for Brain Brigade Inc. You are creating an excel sheet. You use the fill
handle quite often to fill or copy series of values to cells. Every time you use the fill handle, the Auto
Fill button appears. You do not want to display the Auto Fill button. You open the Excel Options
window. Mark the check box that you will clear to accomplish the task.

Martha works as an Office Executive for Tech Profile Inc. She uses Microsoft Excel 2010 to create
office reports. She often needs to fill names of all employees in each department of the company in
her reports. Which of the following steps should she take to ease her task?