Page 30 - iPlus_Ver_2.0_class_8
P. 30
i + COMMON ERRORS
Sometimes when we use wrong type of data, operand or operator in a formula, then error
message is displayed. Given below is the list of errors which commonly occur in Excel.
Errors Reasons
It occurs when the cell contains a number, data or time that is wider than
#### the cell width or when the cell contains a date and/or time formula that
produces a negative result.
#VALUE It occurs when the wrong type of argument or operand is used.
#NAME It occurs when Excel does not recognize text in a formula.
#NUM It occurs when there is a problem with a number in a formula or function.
#REF! It occurs when a cell reference is not valid.
#DIV/0! It occurs when a formula applying division by zero is used.
i + CHARTS IN EXCEL
A chart is a visual or graphical representation of data from a worksheet which is very useful for
instant analysis and decision making. There are various options related to charts that can be
used to display data in a graphical format. It makes it easier to draw comparisons and analyse
the growth, relationships, and trends among the values in a table.
Components of a Chart
• Chart Title: It is the heading text that helps to identify the chart.
• X-axis: It is the horizontal axis known as category axis.
• Y-axis: It is the vertical axis and is known as value axis.
The X and Y axis divide the X-Y plane into four quadrants.
• Plot Area: It is that area of the chart in which the data is plotted.
In a 2-D chart; axis bound the plot area whereas in 3-D charts, walls and floors bound the plot
area.
Gridlines Chart Title
Plot Area
Data Series
Y-axis
X-axis Data Labels
Legend
28
iPlus (Ver. 2.0)-VIII

