購入前に中身を確かめたい方は、GoShikenの無料サンプルをご活用ください。77-427（Microsoft Excel 2013 Expert Part One）の問題集は、実際の問題形式や解答の質をご確認いただいてからご購入いただけます。

Microsoft 77-427 試験概要:

Microsoft 77-427 試験シラバストピック:

Microsoft Excel 2013 Expert Part Oneのよくある疑問を解決します

Microsoft Excel 2013 Expert Part One 認定 77-427 試験問題：

問題 #1

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 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 fetch the password from the list in which you have saved it.
B. You will create a new document.
C. You will ask Microsoft to retrieve the password.
D. You will use a new password.

問題 #2

HOTSPOT
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through
Microsoft
Excel 2013. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will choose to accomplish the task.

問題 #3

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets change. She requests that you help her out to accomplish the task. Which of the following steps would you suggest she take in order to accomplish the task?

A. Select the cell which is to be monitored.
On the Formulas tab in the Formula Auditing group, click Evaluate Formula.
B. Click the New Window option in the Window group on the View tab. Click the Arrange All
option in the Window group on the View tab. Select the Vertical option.
C. Click the New Window option in the Window group on the View tab. Click the Arrange All
option in the Window group on the View tab. Select the Cascade option.
D. Select the cell which is to be monitored.
On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

問題 #4

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2013. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will
Rick use to accomplish the task?

A. Trust Center
B. Form control
C. Evaluate Formula
D. Accounting template

問題 #5

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. You are inserting a new column, next to a column that is already formatted as text.
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. Excel is trying to reference an invalid cell.
D. The contents of the cells that are being compared may have different data types.

解説：