FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following terms refers to a row or column of data in a worksheet that is plotted in a chart?
A
A data series
B
Axis
C
Data label
D
Data table
E
None
Explanation: 

Detailed explanation-1: -Data series = A data series is a row or column of numbers that are entered in a worksheet and plotted in our chart.

Detailed explanation-2: -A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart.

Detailed explanation-3: -A Legend is a key that identifies the color or pattern assigned to each data series in a chart. The most commonly used type of charts in CS101 are scatter and line charts. With scatter and line charts, you can identify trends with trendlines.

Detailed explanation-4: -The data arranged in columns or rows of a worksheet can be plotted in a pie chart. Typically, a pie chart is similar to a circle divided in small sectors representing fractions of the contribution of each category to the whole. These charts generally display only one group of data.

Detailed explanation-5: -The correct answer is Bar charts, line graphs, and pie charts. A chart is a powerful tool that allows you to visually display data in a variety of different chart formats. MS Excel can produce different chart formats such as Bar, Pie, Line, Column, Area, Scatter, Surface, or Radar charts.

There is 1 question to complete.