When a number gets assigned to a variable that already has a value . the new number overwrites the previous value at that memory location the new number gets assigned to a neighboring memory location the computer issues an error the new value is destroyed and the old value remains

Match the following errors with their definitions. a. #name b. #value c. #ref d. 1. when a formula produces output that is too lengthy to fit in the spreadsheet cell 2. when you enter an invalid cell reference in a formula 3. when you type text in cells that accept numeric data 4. when you type in a cell reference that doesn’t exist