
Database and Spreadsheet Quiz
Authored by Hải Đỗ Chí
Information Technology (IT)
8th Grade
Used 10+ 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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
20 questions
Mengenal Ekstensi File
Quiz
•
8th Grade
20 questions
Ujian Harian Kelas 8 (Sem 1)
Quiz
•
8th Grade
20 questions
Chapter 12 Exam Review
Quiz
•
8th Grade
20 questions
ASESMEN DIAGNOSTIK INFORMATIKA KELAS 7
Quiz
•
7th Grade - University
20 questions
STS Informatika Kelas 8 Semester 1
Quiz
•
8th Grade - University
20 questions
Soalan Mengenai Chromebook SKBG 2024
Quiz
•
6th - 8th Grade
20 questions
Herramientas de formato
Quiz
•
8th Grade
15 questions
Variables, tipos de datos y operadores
Quiz
•
8th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Information Technology (IT)
10 questions
Understanding Poetry and Literary Devices
Interactive video
•
4th - 8th Grade
14 questions
finding slope from a graph
Quiz
•
8th Grade
10 questions
Understanding Meiosis
Interactive video
•
6th - 10th Grade
20 questions
Laws of Exponents
Quiz
•
8th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
12 questions
8th U5L9 Linear Models
Quiz
•
8th Grade
15 questions
Making Inferences
Quiz
•
7th - 12th Grade
15 questions
Main Idea and Supporting Details.
Quiz
•
4th - 11th Grade