Page 30 - TP_iPlus_V2.1_Class8
P. 30
Functions Purpose Example
Age = 18
Score = 85
This function returns TRUE if
AND(condition1,
all specified conditions are true; Input:
condition2, ...)
otherwise, it returns FALSE. =AND(Age >= 18, Score >= 60)
Output: TRUE
Age = 16
This function returns TRUE if at least Score = 85
OR(condition1,
one of the specified conditions is true; Input:
condition2, ...)
otherwise, it returns FALSE.
=OR(Age >= 18, Score >= 60)
Output: TRUE
Quick Byte
The common functions like SUM, AVERAGE, MAX, and MIN, can
also be used by using the down arrow of the AutoSum command.
To use other functions, click on the More Functions option.
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.
28
iPlus (Ver. 2.1)-VIII

