DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
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
|
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.
Detailed explanation-3: -Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. Excel supports many types of charts to help you display data in ways that are meaningful to your audience.