USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How does Excel determine what data to use when creating a chart?
|
|
It uses all data on the current worksheet
|
|
|
It uses all data in the current workbook
|
|
|
It uses the selected cell and all adjacent cells
|
|
|
It uses only the selected cells
|
|
|
None
|
Explanation:
Detailed explanation-1: -Right-click the chart and select data source. Click show data from the Chart tab on the ribbon. Click the chart and the cells will be shaded. The chart will display all data that is in adjacent cells.
Detailed explanation-2: -When you create a chart, Microsoft Office Excel determines the axis on which the data series are plotted, based on the number of worksheet rows and columns that are included in the chart, placing the larger number on the horizontal axis.
There is 1 question to complete.