Database and Spreadsheet Quiz
Authored by Hải Đỗ Chí
Information Technology (IT)
8th Grade
Used 12+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which one identifies as a cell range
C2+D3
C2:D3
C2/D3
C2-D3
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
A block of code that is used to perform a single, related action.
Formula
Function
Query
Report
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Raw information, values, facts and figures.
Data sheet
Data
Database
Model
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why the Book Name field cannot be a primary key?
Primary key only accepts the same value
None of them
Book Name can be duplicated
Because this is unusual in database
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
COUNT function checks all the cells in a specified range in a spreadsheet and outputs how many contain a numeric value. Select the correct function format below:
= COUNT B2:C6]
= COUNT (B2:C6)
= COUNT (B2-C6)
COUNT(B2:C6)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
IF function in a spreadsheet, this evaluates (calculates) a condition and returns different values depending on whether it was True or False. Select the correct function format below:
=IF(B4>=100 "big" "small")
=IF(B4>=100, big, small)
=IF(B4>=100,"big","small")
=IF(B4>=100,"big":"small")
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Something that is checked to determine whether it is true or false.
Report
Query
Field
Condition
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
