THE COMMON FUNTION IN EXCEL (PART 1)

Indentify and fix errors in excel.

Common mistakes in excel:

-         Error#####:

+        Reasons: Error occurs when the comlumn’s wildth is not enough to display the calculated results.

+        Fix by increasing the width  of the column or shrink the font size.

-         Error#VALUE:

+        Reasons: The users use data or operator, that join the fomula  not right with the requires of fomula.

+        Example: The mathematical formula calculated on the cell containing the text data type. Fix errors  by entering the address or format the cell containing the data.

-         Error#DIV/0!: Error occurs when a number divided by 0 or  the denominator of the calculation is a cell with no data. Fix errors by Entering a other fomula or other functions.

-         Error#NAME: Error occurs when the excel file is not defined the character in the fomula.

-         Errors#N/A: Error occurs when the cell doesn’t have data to calculate.

-         Errors#NUM!: Error occurs when using the data not right number type. You need to reformat the data involved in formula.