Database&Spreadshet_GR8_4/2024
Authored by Lê Thủy
Computers
9th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
49 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the function SUMIFS do in Excel?
Sums values in a range that meet multiple criteria
Sums values in a range that meet a single criterion
Checks if a condition is met and returns one value if true and another value if false
None of the above
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the feature used to link tables together in the database?
Foreign key
Primary key
Attribute
Relationship
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to find the highest value in a range in Excel?
MAX
MIN
SUM
AVERAGE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which attribute is used to control the format of data added to a database table?
Validation rule
Format
Field size
Input mask
5.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
What does the function TRANSPOSE do in Excel?
Converts text to uppercase
Returns the transpose of a matrix
Converts a column into a row or vice versa
None of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the function COUNT do in Excel?
Counts the number of empty cells in a range
Counts the number of cells containing numbers in a range
Counts the number of non-empty cells in a range
None of the above
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to sum values in Excel?
COUNT
AVERAGE
SUM
MAX
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?
