Microsoft Excel 2013 Expert Part One (077-427) Free Practice Test

Question 1

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 Macro setting, and then delete the slicer from the Macro-enabled slicers list.

B. Click the slicer, and then press Delete.

C. Right-click the slicer, and then click Remove <Name of slicer>.

D. Click the slicer that you want to delete on the Options tab in the Slicer type group.

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to make a slicer available for use in another PivotTable. 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 slicer that you want to share in another PivotTable.

B. In the Slicer Connections dialog box, clear the check box of any PivotTable fields for which you want to disconnect a slicer.

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

D. In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.

Correct Answer: A,D

Question 3

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2013 to prepare sales reports. You have created a quarterly sales report of the department. After entering required data and inserting charts, you want to give a professional look to the document. You want to produce the document with soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to accomplish the task with least administrative burden?

A. Choose one of the pre-built themes.

B. Select all the text of the document.
Change font style to Verdana and font color to light gray. Use vibrant colors for charts.

C. Create a new workbook through a template. Copy all data and charts of the report to the new workbook.

D. Use the SmartArt option.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following are the reasons that are causing the above problem?
Each correct answer represents a complete solution. Choose all that apply.

A. The contents of the cells that are being compared may have different data types.

B. Excel is trying to reference an invalid cell.

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

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

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.
Which of the following options will you choose to accomplish the task?

A. Protect Workbook Structure

B. Protect Current Sheet

C. Mark as Final

D. Encrypt with Password

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

A. Protect Workbook Structure

B. Protect Current Sheet

C. Mark as Final

D. Encrypt with Password

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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. Excel is trying to reference an invalid cell.

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

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

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

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Microsoft Excel 2013 Expert Part One (077-427) Free Practice Test