Excel Lesson 7 Quiz
Authored by Steve Wills
Computers
11th Grade
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
6 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A method of identifying cells in a spreadsheet formula based on their locations, rather than the location of the formula.
2.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A function that calculates the average value of a group of numbers based on a given criteria.
3.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A function that counts the number of cells within a specified range that meet a given criteria.
4.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A function that evaluates a condition as TRUE or FALSE, then returns a unique result for each outcome.
5.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A method of identifying cells in a spreadsheet formula based on the location of the formula, rather than the location of the cells.
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
A function that adds together all of the values in a group of numbers based on a given criteria.
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?
