Form 4 - CSEC Information Technology Quiz
Authored by Jodi-Ann Gayle
Information Technology (IT)
10th Grade
Used 10+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a valid cell reference in Excel?
A12
12A
AB#12
@A12
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the default file extension for Excel workbooks?
.docx
.xlsx
.pptx
.accdb
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The __________ function searches for a value in the first column of a range and returns a value in the same row from another column.
conditions
VLOOKUP
MAX
AVERAGE
highlighting
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Conditional formatting is a feature that applies formatting based on specified __________.
AVERAGE
conditions
VLOOKUP
highlighting
MAX
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a database object in Microsoft Access?
Table
Query
Form
All of the above
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of a primary key in a database table?
To allow duplicate entries
To uniquely identify each record
To store numeric data
To organize data alphabetically
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
A __________ stores data in rows and columns, while a __________ retrieves specific data from one or more tables.
query
consistency
keys
relationships
table
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?
