According to the question, Rick wants the sheet tabs of the sheets containing charts to appear in

red color. In order to accomplish the task,he will take the following steps:

1.Select the sheets containing charts.

C:\Documents and Settings\Administrator\Desktop\1.JPG

2.Right-click on the sheet tabs. Choose the Tab Color option from the shortcut menu.

C:\Documents and Settings\Administrator\Desktop\1.JPG

Answer options A and D are incorrect. These steps will not affect the appearance of the sheet tabs.

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

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.

The various issues with exporting XML data are as follows:

1.MAP CAN BE EXPORTED BUT SOME REQUIRED ELEMENTS ARE NOT MAPPED: This error occurs under the following situations:

The XML map associated with this XML table contains one or more required elements that are not mapped to the XMLtable. Theelement is a recursive structure.

The XML table contains a variety of mixed content.

2.EXCEL CANNOT SAVE THE WORKBOOK BECAUSE IT DOES NOT CONTAIN ANY XML MAPPINGS: Excel cannot save the user's workbook in the XML Data file unless one or more mapped ranges are created.

3.XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE: An XML mapping cannot be exported if the relationship of the mapped element with other elements is not preserved due to the following reasons:

The mapped element's schema definition is contained within a sequence with the following

attributes:

The maxoccurs attribute is not equal to1.

The sequence has more than one direct child element defined or has an extra compositor as a direct child.

Nonrepeating sibling elements with the same repeating parent element are mapped to dissimilar

XML tables.

Various repeating elements are mapped to the same XML table and the recurrence is not defined by an ancestor element.

Child elements from various parents are mapped to the same XML table.

XML schema constructs a list of lists, denormalized data, or a choice construct.

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 usesIn 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 2010. 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, suchas 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

Valuessuch as months, quarters, or years.