Errors in Excel
Authored by lin daw
Computers
7th - 9th Grade
Used 41+ times
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
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
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
