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

when a formula produces output that is too lengthy to fit in the spreadsheet cell

when you enter an invalid cell reference in a formula

#NAME

when you type text in cells that accept numeric data

#VALUE

when you type in a cell reference that doesn’t exist

#REF

answer; (& & );

solution:

this situation is called an ip conflict.

data from a server is sent in small bits called packets. in an ip conflict, some packets will end up in one computer while some other packets will end up in another computer.

so…overall none of the computers get the data as the original message or picture being sent by the server cannot be retrieved with only half the packets. so it will show up as an error.

thus the final answer is d.