Which of the following conditional formulas will return "True"?
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”?
Mark the option that you will choose 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.
Choose the correct steps 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.
Which of the following can be the causes of the issue?
You work as an Office Assistant for CreativeWorld Inc. You are running a presentation through
PowerPoint 2010. While running the slide show, it pauses for a long time. Which of the following can
be the causes of the issue?
Each correct answer represents a complete solution. Choose all that apply.
Choose and reorder the required steps to print a presentation in grayscale.
Choose and reorder the required steps to print a presentation in grayscale.
Mark the option/button in the following image of the Animations tab to copy animation from one object to anoth
Mark the option/button in the following image of the Animations tab to copy animation from one object to another object.
What will you do to accomplish the task?
You work in an office and you are assigned with the task of creating a document. The document has
to be shared with all the employees. You want to restrict the edit, copy, and print permission of all
the shared users. What will you do to accomplish the task?
John has finished typing a document and he wants to save it. Mark the icon that he should choose to accomplish
John has finished typing a document and he wants to save it. Mark the icon that he should choose to accomplish the task.
Choose and reorder the required steps to insert the quick table.
You work as an Office Assistant for www.company.com Inc. You use Microsoft Word 2010 for official
work. You have created a document and you want to insert a predefined table calendar with large
month names and thick week separators. Choose and reorder the required steps to insert the quick table.
Which of the following steps should she take to ease her 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?