Question

Drag each tile to the correct box.

Match each spreadsheet error to its correct cause.
#VALUE
#REF
#NAME
Cause
A formula specifies a cell
that does not exist.
Text is inserted into a formula that
only accepts numeric arguments.
The colon is missing when a range of cells
is specified as an argument of a formula.
A formula produces a result that is
too long to fit in a spreadsheet cell.
Error

Answer 1

Answer: what is the formula? it gets cut off, and the question is super wonky

Step-by-step explanation:

Answer 2

Spreadsheet errors such as #VALUE, #REF, and #NAME indicate issues with inserted text in place of numbers, references to cells that do not exist, and syntax errors in formulas, respectively.

Step-by-step explanation:

The spreadsheet errors you have encountered correspond to different issues you might come across while working with formulas in a spreadsheet application. The correct matches between the errors and their causes are as follows:

• #VALUE - Text is inserted into a formula that only accepts numeric arguments.

• #REF - A formula specifies a cell that does not exist.

Spreadsheet programs show the #VALUE error when a formula includes text or incorrect types of arguments where it expects numbers. The #REF error occurs if your formula refers to a cell that has been deleted or is not available in the spreadsheet. Lastly, the #NAME error appears when there's a typo in a formula function name or when proper syntax, like a colon in a cell range, is missing.