explain any two types of errors in excel with an example.
Answers
Explanation:
Cells containing formulas that result in an error: A formula does not use the expected syntax, arguments, or data types. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. ... However, if a formula in another cell refers to that cell, the formula returns the error value from that cell.
ANSWER
PLZ THANKS AND 5 STAR GIVE ME AND FOLLW AND CHAT AND YOU ARE VERY BEATUFULL
EXPLANE
1. ###### error
Problem: The column is not wide enough to display all the characters in a cell.
Fix: Extend the width of the column.
2. # Div/0! error
Problem: Excel displays this error when a number is divided either by zero (0) or an empty cell.Fix: Change the divider to a value that is not equal to 0.
3. #Name? error
Problem: The text in a formula is not recognised by Excel. This is caused by misspelling the function names. For instance =su(A1:A7) will result in the #Name? error.Fix: Correct the error by entering =sum(A1:A7).
4. #Value! error
Problem: This error will be displayed if the formula includes cells that contain different data types. = B1(85) + B2(75) +B3(data) will result in the #Value! error message.Fix: Replace B3(data) with a numeric value and the error will be corrected.
5. #REF! error
Problem: The error will be displayed when a cell reference is not valid. Deleting cells that were referred by other formulas will cause this error.Fix: Refer the cells to the correct ranges and the error will be corrected.
6. #NUM! error
Problem: The formula or function contains invalid numeric values.Fix: Using $ ,% symbols with the number can result in this error, so avoid using these.
7. #NULL error
Problem: Excel displays this error when you specify an intersection of two areas that do not intersect (cross). The intersection operator is a space character that separates references in a formula. =Sum(A1:A2 C3:C5) returns the #NULL error because the two ranges do not intersect.