Correct Answer:

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: A

The formula will 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.

Correct Answer: ABD

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.

Correct Answer: C

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.