DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data set
|
|
|
Text Data
|
|
|
Data series
|
|
|
Data range
|
|
|
None
|
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 is a window with in the Chart area. It contains the actual chart itself, and includes plotted data, data series, category, and value axis. 4. Legend depicts the colors, patterns, or symbols assigned to the data series.
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: -The data range can contain headings, data, and a spaceholder cell. Headings are text cells that are used as names for categories and series on the chart. You do not have to enter headings, but if you do, they may only appear in the top row and/or left-hand column of the data range.