Font size
WorksheetsForm 4 - CSEC Information Technology Quiz
Total questions: 30
Worksheet time: 16mins
Which of the following is a valid cell reference in Excel?
A12
12A
AB#12
@A12
What is the default file extension for Excel workbooks?
.docx
.xlsx
.pptx
.accdb
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
Conditional formatting is a feature that applies formatting based on specified __________.
AVERAGE
conditions
VLOOKUP
highlighting
MAX
Which of the following is a database object in Microsoft Access?
Table
Query
Form
All of the above
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
A __________ stores data in rows and columns, while a __________ retrieves specific data from one or more tables.
query
consistency
keys
relationships
table
__________ link tables through common fields and ensure data __________.
relationships
table
query
consistency
keys
A table in Microsoft Access cannot have duplicate primary keys.
True
False
Queries can retrieve data only from one table at a time.
True
False
Relationships in a database help prevent redundancy.
True
False
What is the first step in solving a problem?
Identifying the goal
Implementing the solution
Testing the outcome
Documenting the process
Technology can assist problem-solving by:
Performing calculations
Managing large data sets
Simulating scenarios
All of the above
Clearly defining __________ is essential for solving a problem effectively.
steps
goals
schedules
resources
criteria
Breaking a task into smaller __________ ensures manageable progress.
schedules
steps
criteria
goals
resources
Identifying __________, such as time and budget, helps in planning.
steps
criteria
constraints
resources
goals
What is a flowchart used for in program design?
Writing code
Debugging programs
Visualizing program logic
Compiling programs
Which of the following is an example of a high-level programming language?
Assembly
Python
Machine code
Binary
An __________ is a step-by-step set of instructions to solve a problem.
clarity
reusable
modular programming
algorithm
debugging
__________ programming divides a program into smaller, __________ parts.
modular programming
algorithm
reusable
clarity
debugging
What will the following code output? print(2 * 3 + 5)
21
11
16
10
What is the result of the following code? x = 5 x += 3 print(x)
5
3
8
Error
Which data type is the variable x in the code below? x = "Hello, World!"
int
float
str
list
What does the following code do? for i in range(3): print(i)
Prints 1, 2, 3
Prints 0, 1, 2
Prints 0, 1, 2, 3
Error
What is the correct way to create a function in Python?
function myFunc():
def myFunc():
create myFunc():
func myFunc():
What will the following code output? numbers = [1, 2, 3] print(len(numbers))
1
3
2
Error
Which of the following statements will raise an error?
x = 10
y = "10"
z = 10.5
a = 10 + "10"
What will the following code output? x = 7 if x > 5: print("Greater than 5") else: print("5 or less")
Greater than 5
5 or less
Error
None
How do you access the second element of a list in Python? myList = [10, 20, 30]
myList(2)
myList[2]
myList[1]
myList<2>
What is the output of the following code? def add(a, b): return a + b result = add(3, 4) print(result)
3
4
7
Error
