77-427 Exam Questions & Answers

Correct Answer: D

In order to accomplish the task, Rick should take the following steps: Select all the five sheets.

Write a disclaimer message in the A1 cell of the active sheet. Grouping of sheets is a feature provided in Microsoft Office Excel 2013. Selecting more than one sheet groups those sheets. When multiple sheets are grouped, data that a user

enters or edits in the active sheet is reflected in all sheets in the group. To select all sheets, right-click a sheet

tab, and then click Select All Sheets on the shortcut menu.

Users can select multiple sheets by holding the Ctrl key while clicking the sheets. Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and the message will only get inserted in the first sheet. Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets. Users can select multiple sheets by holding the Ctrl key while clicking the sheets. Answer option C is incorrect. Clicking the first sheet after selecting all sheets will ungroup the sheets and the message will only get inserted in the first sheet. Answer options B and A are incorrect. Both these options will work, but Rick will have to work more than required. Grouping sheets is a better option to work simultaneously on multiple sheets.

Correct Answer: D

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.

Correct Answer: A

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

A line chart should be used where category labels are text, and are representing evenly spaced values such as months, quarters, or years.