Online Access Free 77-888 Practice Test

HOTSPOT
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 flow- chart symbols in the report.
Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines, basic geometric shapes, arrows, equation shapes, flowchart
shapes, stars, banners, and callouts. Users can add text, bullets, numbering, and Quick Styles to
these shapes after inserting them in the document. Take the following steps to add a shape in a
document:

Correct Answer:

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You want to find out the matching values. You get an unexpected error that when you attempt to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following steps will you take to resolve the problem? Each correct answer represents a part of the solution. Choose all that apply.

• A.Use the TRIM function in the new column.
• B.Delete the column having the TRIM function.
• C.Remove the unseen spaces at the start or end of the first Macro cell.
• D.Copy the contents of the new column and paste them on the top of the original column by using paste > special > values sequence.
• E.Create a new column subsequent to the one with the additional spaces in it.

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You select the Encrypt with Password option as a protection measure for the document you are sharing. Now, you have to specify a password in the Password box in the Encrypt Document dialog box appeared for editing the document. But you have forgotten the password. What will happen in this situation?

• A.You will create a new document.
• B.You will use a new password.
• C.You will fetch the password from the list in which you have saved it.
• D.You will ask Microsoft to retrieve the password.

HOTSPOT
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network.
You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.

Correct Answer:

Which of the following is used to display a trend based on adjacent data in a clear and compact
graphical representation by taking up a small amount of space?

• A.Trendline
• B.Sparkline
• C.Backstage view
• D.Line chart