DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Legend
|
|
Data table
|
|
Data labels
|
|
Trendline
|
|
None
|
Detailed explanation-1: -Heatmap. The heatmap presents a grid of values based on two variables of interest. The axis variables can be numeric or categorical; the grid is created by dividing each variable into ranges or levels like a histogram or bar chart.
Detailed explanation-2: -Legend. The legend identifies which data series each color on the chart represents.
Detailed explanation-3: -The four basic graphs used in statistics include bar, line, histogram and pie charts.
Detailed explanation-4: -Data that is arranged in columns and rows on an Excel sheet can be plotted in an xy (scatter) chart. A scatter chart has two value axes. It shows one set of numeric data along the horizontal axis (x-axis) and another along the vertical axis (y-axis).