IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 77-427 問題集  / 77-427 問題練習

Microsoft 77-427 問題練習

Microsoft Excel 2013 Expert Part 1 試験

最新更新時間: 2020/11/16,合計50問。

いい買物の日:77-427 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、77-427 問題集を使用してください。

 / 4

Question No : 1
You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report.
You have inserted the sales figures of all sales managers as shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage (provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you select the F8 cell.
Which of the following formulas will you insert to accomplish the task?

正解:
Explanation:
In order to accomplish the task, you will have to insert the following formula:
=$B$3/100 * E8
According to the question, the formula will be inserted in cell F8 and then the cell's border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers and the value is provided in the cell B3. You will have to insert a formula that refers to the B3 cell as an absolute reference. For this you will have to type currency symbol ($) before the row name and column number. In order to accomplish the task, type the following formula in the cell F8:
=$B$3/100 * E8
When absolute reference is used for referencing a cell in a formula, dragging cell's border to another cell does not change the cell's reference.
Answer options B and E are incorrect. This formula references the B3 cell as a relative reference.
After inserting the formula, when the cell's border is dragged, it will change the cell reference relatively.
Answer options A and C are incorrect. Ampersand symbol (&) is not used for referencing cells in Excel.

Question No : 2
You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team Using Microsoft Excel.
You want the report to appear in the following format:






You want the Remark column to be filled through a conditional formula.
The criteria to give the remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook.
You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?

正解:
Explanation:
In order to accomplish the task, you will have to insert the following formula in the F2 cell:
=IF (E2>=1200,"Well Done”, “Improve in Next Quarter")
Answer option A is incorrect. This will display the wrong messages for the given conditions.
The first expression after the logical condition is returned by the IF function when the condition is TRUE.
Answer option B is incorrect. This formula will not accomplish the task as the logical condition is not correct. The specified condition in this formula is testing for values less than or equal to 1200. Whereas, the question's requirement is to evaluate values greater than or equal to 1200.
Answer option D is incorrect. This formula will not accomplish the task because of the two reasons.
First, the equal sign is missing in the condition. Second, the expressions are not in the correct order.

Question No : 3
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

正解:
Explanation:
The following ways are provided by Excel to access and use the stored change history:

Question No : 4
Which of the following steps will you take to merge copies of a shared workbook? Each correct answer represents a part of the solution. Choose all that apply.

正解:
Explanation:
Take the following steps to merge copies of a shared workbook:

Question No : 5
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 at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open () MsgBox Time Worksheets ("Sheet2").Range ("A2").Value =Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.

正解:

Question No : 6
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?

正解:
Explanation:
A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option A is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of months.
Answer option D is incorrect. Evaluate Formula is the formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce any error but are not generating the expected result.
Answer option B is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

Question No : 7
You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You want to return the price per $100 face value of a security that pays interest at maturity.
Which of the following financial functions will you use to accomplish the task?

正解:
Explanation:
Various financial functions (reference) are as follows:

Question No : 8
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics.
Which of the following will Rick use to accomplish the task?

正解:
Explanation:
ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on VBA User Forms. They are used when a user needs more flexible design requirements than those provided by Form controls. They have extensive properties that can be used to customize their appearance, behavior, fonts, and other characteristics. The user can control different events that occur when an ActiveX control is interacted with. He can also write macros that respond to events associated with the ActiveX controls. When a user interacts with the control, the VBA code runs to process any events that occur for that control. The ActiveX controls cannot be added to chart sheets from the user interface or to XLM macro sheets. It is not possible to assign a macro to run directly from the ActiveX control.
Answer option A is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using
VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros.
He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to User Forms, used to control events, or modified to run Web scripts on Web pages.
Answer option B is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of months. Answer option C is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

Question No : 9
Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking.
Which option can be used to view only the relevant records?

正解:
Explanation:
Auto filter is used to filter the record as per the condition by hiding the rest. Defining different filters, you can compare data in multiple ways, so you can glean vital information without wasting vital time.
Answer options B and D are incorrect. There are no such options defined in Excel to filter the records.
Answer options C is incorrect. The Sort function is used to arrange the records in ascending or descending order.

Question No : 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.

正解:

Question No : 11
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2013 application on the network. You open the application and see various changes in Excel 2013. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.



正解:

Question No : 12
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.

正解:
Explanation:
The following steps are taken to input Excel array formulas:

Question No : 13
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.

正解:

Question No : 14
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?

正解:
Explanation:
In order to accomplish the task, you will have to choose one of the pre-built themes.
Document themes work on the overall design of the entire document. It enables users to specify colors, fonts, and variety of graphic effects in a document. Themes change the look and feel of the document.



C:\Documents and Settings\Administrator\Desktop\1.JPG
Microsoft Excel 2013 comes with a large collection of pre-built themes. Users can create their own themes for a document. Themes can be specified through Page Layout > Themes.
Answer option A is incorrect. The SmartArt option does not produce soothing graphic effects, soft fonts, and light colors.
Answer options B and D are incorrect. These options involve manual processing.
Therefore, any formatting done manually will increase the administrative burden.

Question No : 15
Which of the following is used to display a trend based on adjacent data in a clear and compact graphical representation by taking up a small amount of space?

正解:
Explanation:
A sparkline is defined as a tiny chart in the background of a cell. Unlike charts on an Excel Worksheet, sparklines are not objects. It is used because data presented in a row or column is useful, but patterns can be hard to spot at a glance. It is used to display a trend based on adjacent data in a clear and compact graphical representation by taking up a small amount of space.
The benefit of using the sparklines is that these can be printed when a user prints a worksheet that contains them. This feature is not available in charts.
Answer option D is incorrect. The Microsoft Office Backstage view is used to replace the traditional file menu with a new approach that uses In and Out features for efficiency. The improved Ribbon enables users to access their preferred commands rapidly and create custom tabs to personalize the way they work.
Answer option A is incorrect. A trendline is defined in Excel 2013. It is a data visualization tool to display the trend of a particular data range.
It is used to show the slope of data points in a chart. There are various types of trendlines, such as linear trendlines, exponential trendlines, and linear forecast trendlines.
Answer option B is incorrect. Excel provides a column chart facility to display data that is arranged in columns or rows on a worksheet. Line charts are used to display continuous data over time, set against a common scale. In a line chart, category data is distributed along the horizontal axis, and all value data is distributed along the vertical axis. Line charts are ideal for showing trends in data at equal intervals.



C:\Documents and Settings\Administrator\Desktop\1.JPG
A line chart should be used where category labels are text, and are representing evenly spaced Values such as months, quarters, or years.

 / 4