PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which of the following actions will you take to remove the comments?

You work as an Office Assistant for Company Inc. You are reviewing a presentation in PowerPoint
2010. You have sent the presentation to your colleagues to get their feedback on the presentation.
Before presenting the presentation, you have decided to remove some comments from the
presentation. Which of the following actions will you take to remove the comments?

Perform the required actions in the Header and Footer dialog box to accomplish the task.

You work as an Office Assistant for Company Inc. You are creating a presentation about the financial
report of your company. Now you want to add the Confidential Information text to the center
bottom of your presentation on every slide except the first slide of the company. For this, you have
to click on the Header & Footer button. Perform the required actions in the Header and Footer
dialog box to accomplish the task.

you want to change the layout of the presentation as shown in the following format:

You work as an Office Assistant for Company Inc. You are preparing a presentation in PowerPoint
2010. You have inserted a chart in your presentation. After creating the presentation, you want to
change the layout of the presentation as shown in the following format:

Mark the option/button in the following image of the Layout tab to accomplish the task.

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?