Excel Hashtag Errors

Meaning: No value available Causes: Technically, this is not an error value but a special value that you can manually enter into a cell to indicate that you don't yet have a necessary value. a) #N/A b) #DIV/0 c) #NAME?

a) #N/A

Meaning: Wrong type of argument in a function or wrong type of operator Causes: This error is most often the result of specifying a mathematical operation with one or more cells that contain text. a) #VALUE! b) #NUM! c) #NULL! d) #REF!

a) #VALUE!

Meaning: Division by zero Causes: The division operation in your formula refers to a cell that contains the value 0 or is blank. a) #N/A b) #DIV/0 c) #NAME?

b) #DIV/0

Meaning: Problem with a number in the formula Causes: This error can be caused by an invalid argument in an Excel function or a formula that produces a number too large or too small to be represented in the worksheet. a) #VALUE! b) #NUM! c) #NULL! d) #REF!

b) #NUM!

Meaning: Excel doesn't recognize a name Causes: This error value appears when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula. a) #N/A b) #DIV/0 c) #NAME?

c) #NAME?

Meaning: You specified an intersection of two cell ranges whose cells don't actually intersect Causes: Because a space indicates an intersection, this error will occur if you insert a space instead of a comma (the union operator) between ranges used in function arguments. a) #VALUE! b) #NUM! c) #NULL! d) #REF!

c) #NULL!

Meaning: Invalid cell reference Causes: This error occurs when you delete a cell referred to in the formula or if you paste cells over the ones referred to in the formula. a) #VALUE! b) #NUM! c) #NULL! d) #REF!

d) #REF!