Which situation will result in a #REF! error?
#REF!
The formula contains an undefined range
A required operator is omitted in a formula
A nonnumeric agument is used in a function when a numeric value is expected
The cell referenced in the error message has been deleted