Wer die Microsoft Excel 2013 Expert Part One besteht, belegt seine Kompetenz mit einem anerkannten Herstellerzertifikat. Fast2test unterstützt Sie dabei mit 62 Übungsfragen zur 77-427 Prüfung, die inhaltlich eng am offiziellen Prüfungsrahmen erstellt wurden.

Microsoft 77-427 Prüfungsübersicht:

Microsoft 77-427 Prüfungsthemen:

FAQ: Alles Wichtige zur Microsoft 77-427 Zertifizierungsprüfung

Microsoft Excel 2013 Expert Part One 77-427 Prüfungsfragen mit Lösungen

Frage #1

You work as an Office Assistant for Tech Perfect Inc.
You are working in a spreadsheet as shown below:
You want to use Excel Transpose Function for copying the contents of cells B1:B3 into cells A5:C5.
You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel #VALUE! error message because the cells are working independently and the function will not work for each individual cell. Therefore, it is required to make the cells A5:C5 work together as an ARRAY. For this purpose, you are required to use an array formula. Which of the following steps will you take to input Excel array formulas in the spreadsheet?
Each correct answer represents a part of the solution. Choose all that apply.

A. Highlight the range of cells that you want to use as an input in his array formula.
B. Press CTRL-SHIFT-Enter.
C. Press CTRL-SHIFT-Tab to remove the error message.
D. Type the array formula into the first cell.

Frage #2

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 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.
B. 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.
C. Wrong syntax used.
D. 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.

Frage #3

You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook containing the macro.
While doing so, you observe that the Auto_Open macro fails every time. Which of the following are the causes of this?
Each correct answer represents a complete solution. Choose all that apply.

A. The workbook where a user wants to save the Auto_Open macro already contains a VBAprocedure in its Open event.
B. The workbook is opened programmatically using the Open method.
C. The default workbook or a workbook loaded from the XLStart folder is opened before running the macro.
D. The workbook is based on the record button that is disabled by default before running the Auto_Open macro.

Frage #4

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 configure form controls.
B. He will create a PivotChart report.
C. He will create a PivotTable report.
D. He will use stand-alone slicers.

Frage #5

HOTSPOT
You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2013. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flow- chart symbols in the report.
Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines, basic geometric shapes, arrows, equation shapes, flowchart
shapes, stars, banners, and callouts. Users can add text, bullets, numbering, and Quick Styles to
these shapes after inserting them in the document. Take the following steps to add a shape in a
document:

Fragen und Antworten: