Pass4itsure > Microsoft > Microsoft Office Specialist > 77-427 > 77-427 Online Practice Questions and Answers

77-427 Online Practice Questions and Answers

Questions 4

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are required to set the security level temporarily for enabling all macros. Mark the option that you will choose first to accomplish the task.

Hot Area:

Buy Now
Questions 5

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You are trying to intersect two ranges that do not intersect each other. Which of the following errors will be occurred in this situation?

A. #VALUE!

B. #NAME?

C. #NULL!

D. #DIV/0!

Buy Now
Questions 6

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 disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?

Each correct answer represents a part of the solution. Choose all that apply.

A. Clear the check box of any PivotTable fields for which you want to disconnect a slicer.

B. Right-click the slicer, and then click Remove .

C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort and Filter group.

D. Click the slicer, and then press Delete.

Buy Now
Questions 7

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. To assign an existing macro to the graphic object, double-click the macro or enter its name in The Macro name box.

B. Click the arrow next to Shape Outline, and then click No Outline. C. Right-click the created hot spot, and then click Assign Macro.

C. 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.

D. Click the name of the macro in the Macro name box, click Edit, and then click OK to edit an existing macro.

E. Click the arrow next to Shape Fill, and then click No Fill on the Format tab.

F. 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.

G. Select the hot spot in the worksheet to display Drawing Tools for adding the Format tab.

H. 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.

Buy Now
Questions 8

Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2013. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer message in the A1 cell of each sheet in the workbook as shown in the image given below:

Which of the following is the easiest way to accomplish the task?

A. Write a disclaimer message in the A1 cell of the first sheet. Copy the disclaimer message and paste it on the remaining sheets.

B. Write a disclaimer message in the A1 cell of the first sheet. In the other sheets, insert a formula that points to the A1 cell of the first worksheet.

C. Select all the five sheets. Click the first sheet. Write a disclaimer message in the A1 cell of the active sheet.

D. Select all the five sheets. Write a disclaimer message in the A1 cell of the active sheet.

Buy Now
Questions 9

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. Click the slicer that you want to delete on the Options tab in the Slicer type group.

B. Click the Macro setting, and then delete the slicer from the Macro-enabled slicers list.

C. Click the slicer, and then press Delete.

D. Right-click the slicer, and then click Remove .

Buy Now
Questions 10

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. 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. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.

B. Click Insert Slicer in the Sort and Filter group on the Options tab.

C. Hold down CTRL, and then click the items on which you want to filter.

D. Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.

E. Click anywhere in the PivotTable report for which you want to create a slicer.

Buy Now
Questions 11

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining financial budget and other financial calculations. You want to return the depreciation of an asset for a specified period by using the fixed-declining balance method and to return the future value of a starting principal after applying a series of compound interest rates.

Which of the following financial functions will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

A. DB function

B. NPV function

C. DDB function

D. FVSCHEDULE function

Buy Now
Questions 12

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network.

Rick wants to display data series, categories, data markers, and axes in the report. Which of the

following actions will Rick take to accomplish the task?

A. He will use stand-alone slicers.

B. He will create a PivotTable report.

C. He will configure form controls.

D. He will create a PivotChart report.

Buy Now
Questions 13

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet.

You are facing a problem that when you type in a function and press Enter, the cell shows the function as you typed it, instead of returning the function's value as shown below:

Which of the following is the reason that is causing the above problem?

A. You are inserting a new column, next to a column that is already formatted as text.

B. Excel is trying to reference an invalid cell.

C. You are inserting a new column, next to a column containing Dates or Times.

D. The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.

Buy Now
Exam Code: 77-427
Exam Name: Excel 2013 Expert Part One
Last Update: Mar 21, 2024
Questions: 62
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$45.99

VCE

$49.99

PDF + VCE

$59.99