FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which data arrangement is ideal for a pie chart?
A
Multiple rows and columns of data
B
A single row or column of data
C
A single cell of conditionally formatted data
D
Any number of rows and columns; however, data must be in a table
E
None
Explanation: 

Detailed explanation-1: -Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie. Consider using a pie chart when: You have only one data series.

Detailed explanation-2: -Click Pie, and then click Pie of Pie or Bar of Pie. To change what displays in the secondary pie, click the piece of pie you’re expanding, and then in the Split Series By box of the Format Data Series pane-click the type of data to display in the secondary chart.

Detailed explanation-3: -pie charts. In one column or row, and one column or row of labels. This chart can use one or more data series.

There is 1 question to complete.