Search Header Logo

Errors in Excel

Authored by lin daw

Computers

7th - 9th Grade

Used 41+ times

Errors in Excel
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

A cell with an invalid formula displays an error value and a green ________ in the upper-left corner of the cell. 

circle

triangle

square

check mark

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When the Formula is trying to divide by zero, you would see this error

#DIV/0

#REF

#NUM

#VALUE

####

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When the formula is using the wrong type of  argument, such as a label instead of a value, you would see this error

#DIV/0

#REF

#NUM

#VALUE

####

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When the formula contains a cell address OR cell reference that is not valid., you would see this error

#DIV/0

#REF

#NUM

#VALUE

####

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When a numeric value is invalid, such as too large or too small, you would see this error

#DIV/0

#REF

#NUM

#VALUE

####

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When a numeric value is invalid, such as too large or too small, you would see this error

#DIV/0

#REF

#NUM

#VALUE

####

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When the result of the formula is too wide to fit in the column or the result of a negative time, or date value.  If the result should fit in the column, check the formula for errors., you would see this error

#DIV/0

#REF

#NUM

#VALUE

####

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?