Free Microsoft 077-427 Exam Dumps Questions & Answers

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You are creating a hot spot on a graphic that other users can click to run a macro. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.  Click the name of the macro in the Macro name box, click Edit, and then click OK to edit an existing macro.
• B.  Select the hot spot in the worksheet to display Drawing Tools for adding the Format tab.
• C.  To assign an existing macro to the graphic object, double-click the macro or enter its name in The Macro name box.
• D.  Click the arrow next to Shape Outline, and then click No Outline. Right-click the created hot spot, and then click Assign Macro.
• E.  Click Record, type a name for the macro in the Record Macro dialog box, and then click OK to start the recording of the macro.
• F.  Click Slicer, type a name for the macro in the Slicer Macro dialog box, and then click OK to start the recording of the macro.
• G.  To create a hot spot on the existing object, on the Insert tab, in the Illustrations group, Click Shapes, select the shape that you want to use, and then draw that shape on the existing object.
• H.  Click the arrow next to Shape Fill, and then click No Fill on the Format tab.

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

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You have changed some data in the worksheet of the company. You are submitting the sell workbook of the company to the Administrator of the company for comments. Now, you want to merge input that you receive into a copy of that workbook, including the changes and comments that you want to keep. For this purpose, it is required to access and use the stored change history. Which of the following will you use to accomplish the task?

• A.  Onscreen highlighting
• B.  Reviewing of changes
• C.  History tracking
• D.  Slicer-enabled highlighting

DRAG DROP
You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front
of their descriptions.

Correct Answer:

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to delete the slicer. Which of the following steps can you take to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

• A.  Right-click the slicer, and then click Remove <Name of slicer>.
• B.  Click the slicer that you want to delete on the Options tab in the Slicer type group.
• C.  Click the Macro setting, and then delete the slicer from the Macro-enabled slicers list.
• D.  Click the slicer, and then press Delete.