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