Mark the appropriate sign to accomplish the task.
You work as a Support Analyst for Soft Well Inc. You create a presentation for a business meeting.
The business meeting is going to be held between you and some Chinese associates. You write some
information on the slides of the presentation in English language. After writing the concepts, you
want to use the Chinese language instead of English language, so that it can be better
understandable by the meeting attendees. Mark the appropriate sign to accomplish the task.
Which of the following actions will he take to accomplish the task?
Alan works as a Sales Manager for MVP Technologies. He is creating a sales report in Microsoft Excel
2010. In the report, he needs to enter the names of sales executives in one column and the sales
target (in dollars) achieved by them in the next column as shown in the image below:
He wants to ensure that the color of a cell changes automatically to orange when the sales figure
entered in the cell is more than $10,000. Which of the following actions will he take to accomplish the task?
Which of the following steps will you take next to accomplish the task?
You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint
2010. You want to add a Unicode (hex) symbol as a bullet for main points. You have clicked the
Bullets drop-down list and selected the Bullets and Numbering option. Which of the following steps
will you take next to accomplish the task?
Mark the option/button in the following image of the Design tab on which you will click to accomplish the task
You work as an Office Assistant for Company Inc. You are creating a presentation in which you want
to customize the slides of the presentation as follows:
1.The width of the slides in the presentation will be 10 inches and the height will be 7 inches.
2.The slide numbering must start from 3.
3.The notes, handouts, and outline must be in landscape orientation.
Mark the option/button in the following image of the Design tab on which you will click to
accomplish the task.
Which of the following options should he use to accomplish the task?
Rick works as an Office Executive for Perfect Wear Inc. He uses Microsoft Excel 2010 to maintain
sales record of each day. He needs to print the daily sales report. The management of the company
wants to ensure that each crucial report printed, must print a picture named conf.gif as a watermark
showing the confidential message.
Which of the following options should he use to accomplish the task?
You have to open an existing worksheet through the application.
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the
Microsoft Excel 2010 application on the network. You open the application and see various changes
in Excel 2010. You have to open an existing worksheet through the application. You are unable to
find the Office button.
Mark the option you will choose to accomplish the task.
You work as an Office Assistant for Media Perfect Inc. You are creating a report in a workbook in
Microsoft Excel 2010. You have to insert a Venn-diagram in a worksheet. Mark the option you will
choose to accomplish the task.
Choose the required steps to accomplish the tasks.
You work as an Office Assistant for Tech Perfect Inc. You create a worksheet in Excel 2010 that
contains various tables, headings, charts, and SmartArt objects. In order to give it a professional
look, you choose Office theme as shown below:
You like the appearance of the sheet in this theme; however, you want to use the Lucida Calligraphy
font for heading and Arial font for the body text. You often use this font combination for formatting
office sheets. You are required to accomplish the following tasks:
Use the font combination in your current document.
Enable Excel to provide this combination in other office documents too.
Choose the required steps to accomplish the tasks.
Which of the following actions will you take to accomplish the task?
You work as System Analyst for Company Inc. You are creating a presentation in PowerPoint 2010.
The presentation comprises various controls. You want to create a text box that comprises two
columns. Which of the following actions will you take to accomplish the task?
What is the most likely cause?
You work as a Sales Manager for Blue Well Inc. You have to create a report in Excel 2010 in the
following format:
You want to insert formulas in the cells in the First Quarter column. These cells will display the sum
of values of respective columns in January, February, and March columns. For this, you insert the
following formula in the E2 cell:
=sum(B2:D2)
However, Excel is treating the formula as a text and displaying it in the following format:
What is the most likely cause?