Question

Drag the tiles to the correct boxes to complete the pairs.
Match the following errors with their definitions.
#NAME
#VALUE
#REF
#####
when a formula produces output that is too lengthy to fit in the spreadsheet cell
arrowRight
when you enter an invalid cell reference in a formula
arrowRight
when you type text in cells that accept numeric data
arrowRight
when you type in a cell reference that doesn’t exist
arrowRight

Answer 1

Here are the correct pairs matched with their definitions:

1. **#NAME**
- when you type text in cells that accept numeric data

2. **#VALUE**
- when you enter an invalid cell reference in a formula

3. **#REF**
- when you type in a cell reference that doesn’t exist

4. **#####**
- when a formula produces output that is too lengthy to fit in the spreadsheet cell