Microsoft 77-427 Online Practice Questions and Exam Preparation

Microsoft 77-427 Online Questions & Answers

• Question 51:

  You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You want to change values in cells to observe the way in which those changes are affecting the outcome of formulas in the worksheet. Which of the following will you use to accomplish the task?

  A. Form control
  B. Trust Center
  C. Accounting template
  D. What-if analysis
  D. What-if analysis

  ---

  What-if analysis is defined as the process of changing values in cells to observe the way in which those changes are affecting the outcome of formulas in the worksheet. There are three types of what-if analysis tools that are named as scenarios, data tables, and Goal Seek. A user can also install the Solver add-in to accommodate more variables than Goal Seek. 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 UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option C 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 B is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

• Question 52:

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

  ---

  The PivotChart report is used to provide a graphical representation of data in a PivotTable report in an interactive way. Whenever a user creates the PivotChart report, PivotChart report filters are displayed in the chart area. These are used for

  sorting and filtering the underlying data of the PivotChart report. Changes made to the layout and data in the associated PivotTable report are immediately reflected in the layout and data in the PivotChart report. The PivotChart report shows

  data series, categories, data markers, and axes in the same way as the standard charts do. It is possible to change the chart type and other options such as titles, legend placement, data labels, and chart location. Answer option A is incorrect.

  Stand-alone slicers are referenced from Online Analytical Processing (OLAP) Cube functions. These stand-alone slicers can be connected with any PivotTable in future.

  They can be added by using the slicer button on the Ribbon. They need to be manually linked into grids as required.

  Answer option C 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 UserForms, used to control events, or modified to run Web scripts on Web pages.

  Answer option B is incorrect. A PivotTable report is used to summarize large amounts of data, to analyze numerical data, and to answer unexpected questions about data.

• Question 53:

  You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values in the columns. While doing so, you get an unexpected error that when you attempt to look up or match a lookup_value within an array; Excel is not able to recognize the matching value. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. 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. Select the Text to Columns option from the Data tab at the top of the Excel workbook.
  B. Select Text and click the Finish button in Column Data Formats.
  C. Select the Delimited option and click Next
  D. Make sure that all delimiter options are unselected, and then again click Next.
  E. Remove the unseen spaces at the start or end of the first Macro cell.
  F. Select the cells to convert their data to text.
  A. Select the Text to Columns option from the Data tab at the top of the Excel workbook.
  B. Select Text and click the Finish button in Column Data Formats.
  C. Select the Delimited option and click Next
  D. Make sure that all delimiter options are unselected, and then again click Next.
  F. Select the cells to convert their data to text.

  ---

  In this situation, you will take the following steps:

  1.

  Select the cells to convert their data to text.

  2.

  Select the Text to Columns option from the Data tab at the top of your Excel workbook.

  3.

  Select the Delimited option and click Next.

  4.

  Make sure that all delimiter options are unselected, and then again click Next.

  5.

  Select Text and click the Finish button in Column Data Formats.

• Question 54:

  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. Create a copy of a slicer connected with the PivotTable.
  B. Create a slicer connected with the PivotTable.
  C. Create a slicer by disabling Macros associated with the PivotTable.
  D. Use an existing slicer connected with another PivotTable.
  A. Create a copy of a slicer connected with the PivotTable.
  B. Create a slicer connected with the PivotTable.
  D. Use an existing slicer connected with another PivotTable.

  ---

  The various ways to use or create slicers to filter PivotTable data in an existing PivotTable are as follows:

  1.

  Create a slicer connected with the PivotTable.

  2.

  Create a copy of a slicer connected with the PivotTable.

  3.

  Use an existing slicer connected with another PivotTable.

  Answer option C is incorrect. This is an invalid answer option.

• Question 55:

  You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a 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 OK.
  B. Choose Select a table or range under Choose the data that you want to analyze.
  C. Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
  D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
  E. Click a cell in the cell range that contains data for using worksheet data as the data source.
  A. Click OK.
  B. Choose Select a table or range under Choose the data that you want to analyze.
  D. Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
  E. Click a cell in the cell range that contains data for using worksheet data as the data source.

• Question 56:

  You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2013. You have arranged sales data as shown below:

  

  You want to provide pictorial representation of the trend of the sales data in front of each row.

  Which of the following actions will you take to accomplish the task with the least amount of administrative burden?

  A. Use stand-alone slicers.
  B. Configure form controls.
  C. Create sparklines.
  D. Create a PivotTable report.
  C. Create sparklines.

  ---

  

  In order to accomplish the task with the least amount of administrative burden, use sparklines.

  Sparklines, introduced in Microsoft Office 2013, are tiny charts that can fit in a cell. The sparklines can be used to show trends in a small amount of space. The sparklines visually summarize trends alongside data.

  The sparklines can be added through the Insert tab. Answer option A is incorrect. Stand-alone slicers are referenced from Online Analytical Processing (OLAP) Cube functions. These stand-alone slicers can be connected with any PivotTable

  in future.

  They can be added by using the slicer button on the Ribbon. They need to be manually linked into grids as required.

  Answer option B 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 UserForms, used to control events, or modified to run Web scripts on Web pages.

  Answer option D is incorrect. A PivotTable report is used to summarize large amounts of data, to analyze numerical data, and to answer unexpected questions about data.

• Question 57:

  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. Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
  B. Right-click the slicer, and then click Remove .
  C. Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort and Filter group.
  D. Click the slicer, and then press Delete.
  A. 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 and Filter group.

• Question 58:

  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.

  A. History tracking
  B. Onscreen highlighting
  C. Slicer-enabled highlighting
  D. Reviewing of changes
  A. History tracking
  B. Onscreen highlighting
  D. Reviewing of changes

  ---

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

  1.

  Onscreen highlighting: It is used when a workbook does not contain many changes and a user wants to see all changes at a glance.

  2.

  History tracking: It is used when a workbook has many changes and a user wants to investigate what occurred in a series of changes.

  3.

  Reviewing of changes: It is used when a user is evaluating comments from other users. Answer option C is incorrect. This is an invalid answer option.

• Question 59:

  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?

  A. Form control
  B. Accounting template
  C. Trust Center
  D. ActiveX control
  D. ActiveX control

  ---

  ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on VBA UserForms. 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 UserForms, 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 60:

  Which of the following can be defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter?

  A. Accounting templates
  B. ActiveX controls
  C. Form controls
  D. Slicers
  D. Slicers

  ---

  Slicers are defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter.

  When a user uses a regular PivotTable report filter to filter on multiple items, the filter indicates only that multiple items are filtered and the user has to open a drop-down list to find the filtering details. However, a slicer clearly labels the filter

  that is applied and provides details so that the data displayed in the filtered PivotTable report can be easily understood.

  Answer option B is incorrect. ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on VBA UserForms.

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