FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A ____ is a row or column of numbers in a worksheet that are plotted in a chart.
A
Data set
B
Text Data
C
Data series
D
Data range
E
None
Explanation: 

Detailed explanation-1: -A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits. Charts in Office are always associated with an Excel-based worksheet, even if you created your chart in another program, such as Word.

Detailed explanation-2: -Plot area:-Plot area is a window within the Chart area. It contains the actual chart itself, and includes plotted data, data series, category, and value axis.

Detailed explanation-3: -Click anywhere in the chart that contains the data series that you want to plot on different axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/Column.

Detailed explanation-4: -A data range is a contiguous set of cells. The series option lets you use data from different sections of you data model. Each series correspons to one ‘line’ on the chart.

There is 1 question to complete.