name any two error results displayed in ms Excel and state Thier possible reason
Answers
Answered by
7
When using Microsoft Excel, you may encounter a few common Excel errors while creating or working with formulas. It’s important to learn how to correct these errors, otherwise you may risk the chance of unintended results being displayed on your spreadsheet.
In this week’s tip, we take a look at a few of the common Excel errors and how to easily correct them.
Applies To: Microsoft Excel 2010, 2013, and 2016.
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.
In this week’s tip, we take a look at a few of the common Excel errors and how to easily correct them.
Applies To: Microsoft Excel 2010, 2013, and 2016.
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.
Similar questions