FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following options allow you to modify chart elements?
A
The Format task pane or Chart Tools Ribbon
B
The Data tab on the Ribbon
C
The Page Layout tab on the Ribbon
D
The Chart Elements task pane
E
None
Explanation: 

Detailed explanation-1: -You can change the format of individual chart elements, such as the chart area, plot area, data series, axes, titles, data labels, or legend. Two sets of tools are available for formatting chart elements: the Format task pane and the Chart Tools Ribbon. For the most control, use the options in the Format task pane.

Detailed explanation-2: -Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK. Changes you make may break links to the source data on the worksheet.

Detailed explanation-3: -Modification Tools. Chart Design tab offers tools for chart modification: chart layouts, chart styles, data, and change chart type.

There is 1 question to complete.