DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Axis or Chart Title(s)
|
|
|
Column and row title(s)
|
|
|
Data title(s)
|
|
|
Legend title(s)
|
|
|
None
|
Detailed explanation-1: -The correct answer is A chart can have a chart title, legends and axis titles. Title-It is a text box that can be placed anywhere on the chart. Chart legend-It shows what kind of data is represented in the chart. By default, the text that appears in the legend is taken from the chart’s data range.
Detailed explanation-2: -Axis labels are the text labels that appear along the horizontal and vertical axes of a chart. They can be used to indicate the units of measure for the data plotted on the chart, or to provide descriptive text about the data.
Detailed explanation-3: -In a chart you create, axis labels are shown below the horizontal (category, or “X") axis, next to the vertical (value, or “Y") axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its source data for these axis labels.
Detailed explanation-4: -By default, excel can make at most two axis in the graph. There is no way to make a three-axis graph in excel.
Detailed explanation-5: -Click anywhere within your Excel graph to activate the Chart Tools tabs on the ribbon. On the Layout tab, click Chart Title > Above Chart or Centered Overlay.