077-427試験無料問題集（62題）「Microsoft Excel 2013 Expert Part One 認定」

出題：1

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

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

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. Right-click the slicer, and then click Remove <Name of slicer>.

B. Click the slicer, and then press Delete.

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

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

正解：C,D 解答を投票する

出題：3

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly 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 required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

A. Use an existing slicer connected with another PivotTable.

B. Create a slicer by disabling Macros associated with the PivotTable.

C. Create a slicer connected with the PivotTable.

D. Create a copy of a slicer connected with the PivotTable.

正解：A,C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You are creating a chart in Excel 2013. You want to show the slope of data points in the chart to know the trend of the Business Intelligence data range. Which of the following will you use to accomplish the task?

A. Trendline

B. Backstage view

C. Sparkline

D. Line charts

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

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. Hold down CTRL, and then click the items on which you want to filter.

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

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

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

E. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
you
want to create a slicer.

正解：A,B,D,E 解答を投票する

出題：6

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. 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. You are inserting a new column, next to a column containing Dates or Times.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:
VLOOKUP(12, A2:C10, 3, FALSE )
Which of the following actions will be performed by the formula?

A. Search the value 12 in the third column of the range and then returns the value that is contained in the 12th column of the range and on the same column as the lookup value.

B. Wrong syntax used.

C. Search the value 3 in the last column of the range, and then returns the value that is in the column of the range and on the same row as the lookup value.

D. Search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

077-427試験無料問題集「Microsoft Excel 2013 Expert Part One 認定」