Ex - Basic Functions 2
Authored by Wan-hsuan Lin
Computers
9th - 12th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of a spreadsheet function?
=sum(A2:A10)
Function(Sum(A2:A10))
sum=(A2:A10)
=(A2:A10)Sum
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The __________ function is used to determine the number of cells that contain NUMBERS/VALUES.
=SUM( )
=COUNT( )
=COUNTA( )
=AVERAGE( )
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function will display the number of cells that have TEXT or NUMBERS in them?
=COUNTA( )
=SUM( )
=AVERAGE( )
=COUNT( )
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
_________ functions is used to determine the number of cells that are NOT EMPTY.
=AVERAGE( )
=SUM( )
=COUNT( )
=COUNTA( )
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
All functions have three parts: Equal Sign, Function Name and __________________.
Argument
Formula
Relational Operators
Logical Operators
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
B5:G10 is best described as a_____________.
Cell References
Value
Range
Formula
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which expression will determine the number of numeric values in the range, B2:B6?
=COUNT(B2:B6)
=COUNTA(B2:B6)
=COUNT(B2-B6)
=COUNTA(B2-B6)
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
