Excel
Authored by Ollie Hart
Computers
8th Grade
Used 32+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
calculates the simple average of a set of numbers
SUM
AVERAGE
MIN
MAX
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
counts the number of cells in a range of cells that contain numbers
AVERAGE
MIN
COUNT
MAX
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
show a result based on a criteria being met, and a different result if the criteria is not met TRUE? FALSE?
IF Function
Median
Mode
Vlookup
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
combines blocks of text
adding
copying
text wrap
concatenate
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
error which occurs when the cell reference is not valid
####
#REF!
#NUM!
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
error which occurs when a misspelling has occurred in a function name
####
#REF!
NAME?
NUM!
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
error which occurs when the column is not wide enough to display the contents of a cell
####
#REF!
#NAME?
#NUM!
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?
