Errors in Excel

A cell with an invalid formula displays an error value and a green ________ in the upper-left corner of the cell. 

• circle

• triangle

• square

• check mark

When the Formula is trying to divide by zero, you would see this error

• #DIV/0

• #REF

• #NUM

• #VALUE

• ####

When the formula is using the wrong type of  argument, such as a label instead of a value, you would see this error

• #DIV/0

• #REF

• #NUM

• #VALUE

• ####

When the formula contains a cell address OR cell reference that is not valid., you would see this error

• #DIV/0

• #REF

• #NUM

• #VALUE

• ####

When a numeric value is invalid, such as too large or too small, you would see this error

• #DIV/0

• #REF

• #NUM

• #VALUE

• ####

When a numeric value is invalid, such as too large or too small, you would see this error

• #DIV/0

• #REF

• #NUM

• #VALUE

• ####

When the result of the formula is too wide to fit in the column or the result of a negative time, or date value.  If the result should fit in the column, check the formula for errors., you would see this error

• #DIV/0

• #REF

• #NUM

• #VALUE

• ####

Excel automatically checks a formula for errors when it is entered into a cell. 

• true

• false