Junior Certificate Examination
Digital Technologies
Q301.
In a spreadsheet, what does the formula =AVERAGE(B2:B10) calculate?
A
Sum of B2 to B10
B
Average of B2 to B10
C
Count of B2 to B10
D
Maximum value of B2 to B10
Correct Answer: B
AVERAGE returns the mean of the specified range.
Junior Certificate Examination
Digital Technologies
Q302.
Which of the following is an example of a cloud storage service?
A
External hard drive
B
USB flash drive
C
Google Drive
D
CD-ROM
Correct Answer: C
Google Drive is a cloud-based storage solution.
Junior Certificate Examination
Digital Technologies
Q303.
Which hardware component is considered the "brain" of the computer?
A
Motherboard
B
CPU
C
RAM
D
Hard drive
Correct Answer: B
The CPU processes instructions and performs calculations.
Junior Certificate Examination
Digital Technologies
Q304.
Which peripheral device is primarily used to input images into a computer?
A
Printer
B
Scanner
C
Projector
D
External drive
Correct Answer: B
Scanners capture images and convert them to digital format.
Junior Certificate Examination
Digital Technologies
Q305.
What is the first step in cleaning a computer's internal components?
A
Remove the power supply
B
Turn off the computer and unplug it
C
Open the case immediately
D
Apply cleaning fluid directly to components
Correct Answer: B
Safety requires the system to be powered off and unplugged before cleaning.
Junior Certificate Examination
Digital Technologies
Q306.
Which of these is a common sign of overheating in a computer?
A
Blue screen of death
B
Loud fan noise
C
Slow startup time
D
Random rebooting
Correct Answer: B
Overheating often causes the fan to run loudly to cool components.
Junior Certificate Examination
Digital Technologies
Q307.
What does the operating system reinstall process typically involve?
A
Only backing up user data
B
Formatting the hard drive and reinstalling OS files
C
Installing new hardware components
D
Updating BIOS firmware
Correct Answer: B
Reinstalling an OS usually includes formatting the drive and copying OS files.
Junior Certificate Examination
Digital Technologies
Q308.
Which of the following is a basic troubleshooting step for a non-responsive application?
A
Restart the computer
B
Delete the application folder
C
Change the desktop wallpaper
D
Increase RAM size
Correct Answer: A
Restarting often resolves temporary application issues.
Junior Certificate Examination
Digital Technologies
Q309.
In database design, what is a primary key?
A
A field that holds the largest data value
B
A unique identifier for each record
C
A field that can be duplicated
D
A field used for sorting only
Correct Answer: B
Primary keys uniquely identify each record in a table.
Junior Certificate Examination
Digital Technologies
Q310.
Which spreadsheet function returns the smallest number in a range?
A
MIN
B
MAX
C
SMALL
D
SUM
Correct Answer: A
MIN returns the minimum value of the specified range.
Junior Certificate Examination
Digital Technologies
Q311.
What does the COUNT function in a spreadsheet do?
A
Counts the number of cells that are blank
B
Counts the number of cells that contain numbers
C
Counts the total number of cells in a range
D
Counts the number of formulas in a sheet
Correct Answer: B
COUNT counts cells with numeric values.
Junior Certificate Examination
Digital Technologies
Q312.
Which of these is a correct relative cell reference?
Correct Answer: C
A1 is a relative reference that changes when copied.
Junior Certificate Examination
Digital Technologies
Q313.
In a database, a form is used primarily for:
A
Displaying data in tabular format
B
Entering and editing records
C
Running queries
D
Generating reports
Correct Answer: B
Forms provide a user-friendly interface for data entry.
Junior Certificate Examination
Digital Technologies
Q314.
Which of the following is an example of a removable external storage device?
A
SSD
B
HDD
C
USB flash drive
D
Optical drive
Correct Answer: C
USB flash drives are portable and removable.
Junior Certificate Examination
Digital Technologies
Q315.
What is the purpose of a report in a database application?
A
To input new data
B
To display data in a formatted layout
C
To edit existing records
D
To store backup copies
Correct Answer: B
Reports format and present data for printing or review.
Junior Certificate Examination
Digital Technologies
Q316.
Which of the following best describes a mixed reference in a spreadsheet?
Correct Answer: B
A$1 is a mixed reference with a fixed row and relative column.
Junior Certificate Examination
Digital Technologies
Q317.
In spreadsheet sorting, what does "ascending" order mean?
A
Largest to smallest
B
Smallest to largest
C
Alphabetical Z to A
D
Alphabetical A to Z
Correct Answer: B
Ascending means values increase from lowest to highest.
Junior Certificate Examination
Digital Technologies
Q318.
Which hardware component stores data permanently?
Correct Answer: C
SSDs (solid-state drives) provide non-volatile storage.
Junior Certificate Examination
Digital Technologies
Q319.
What is the function of a motherboard in a computer?
A
Process data
B
Store data permanently
C
Connect all components together
D
Display graphics
Correct Answer: C
The motherboard provides the circuitry and slots for components.
Junior Certificate Examination
Digital Technologies
Q320.
Which of the following is NOT a form of backup?
A
Cloud backup
B
External hard drive backup
C
Manual data entry
D
Network attached storage backup
Correct Answer: C
Manual data entry is not a backup method.
Junior Certificate Examination
Digital Technologies
Q321.
In a database, what is a query used to do?
A
Create a new table
B
Retrieve specific data based on conditions
C
Export data to a spreadsheet
D
Backup the database
Correct Answer: B
Queries filter and retrieve data according to criteria.
Junior Certificate Examination
Digital Technologies
Q322.
Which of these is a correct way to reference a cell in another worksheet?
A
Sheet1!A1
B
Sheet1:A1
C
Sheet1 A1
D
Sheet1A1
Correct Answer: A
The exclamation mark separates sheet name and cell reference.
Junior Certificate Examination
Digital Technologies
Q323.
What does the SUM function in a spreadsheet calculate?
A
The average of a range
B
The total of a range
C
The maximum value in a range
D
The count of cells in a range
Correct Answer: B
SUM returns the total of numeric values in a range.
Junior Certificate Examination
Digital Technologies
Q324.
Which of the following is a typical symptom of a faulty power supply?
A
Slow boot time
B
Random reboots
C
Overheating CPU
D
All of the above
Correct Answer: D
Faulty power supplies can cause various hardware issues.
Junior Certificate Examination
Digital Technologies
Q325.
In database terminology, what is a field?
A
A table that holds records
B
A single piece of data within a record
C
A form for data entry
D
A query that retrieves data
Correct Answer: B
A field is a column in a table representing a data attribute.
Junior Certificate Examination
Digital Technologies
Q326.
Which of these is a common security threat in cybersecurity?
A
Phishing
B
Cloud storage
C
External hard drive
D
USB flash drive
Correct Answer: A
Phishing is a deceptive technique to steal information.
Junior Certificate Examination
Digital Technologies
Q327.
Which of the following is a type of cloud computing service?
Correct Answer: A
IaaS (Infrastructure as a Service) is a cloud computing model.
Junior Certificate Examination
Digital Technologies
Q328.
Which of these is an example of an emerging technology?
A
Blockchain
B
Hard drive
C
Printer
D
Keyboard
Correct Answer: A
Blockchain is a relatively new technology.
Junior Certificate Examination
Digital Technologies
Q329.
What does "digital citizenship" emphasize?
A
Buying digital products
B
Responsible use of technology
C
Installing software updates
D
Using computers for gaming only
Correct Answer: B
Digital citizenship focuses on responsible, ethical technology use.
Junior Certificate Examination
Digital Technologies
Q330.
Which of the following is a protective measure against malware?
A
Ignoring security updates
B
Using a firewall
C
Opening unknown email attachments
D
Disabling antivirus software
Correct Answer: B
A firewall helps block malicious traffic.
Junior Certificate Examination
Digital Technologies
Q331.
In a spreadsheet, which function returns the number of cells that are not empty?
A
COUNTA
B
COUNTIF
C
COUNT
D
SUM
Correct Answer: A
COUNTA counts cells that contain any data.
Junior Certificate Examination
Digital Technologies
Q332.
Which of the following is a component of the internal computer hardware?
A
Printer
B
Scanner
C
Motherboard
D
Projector
Correct Answer: C
The motherboard is an internal component.
Junior Certificate Examination
Digital Technologies
Q333.
Which peripheral device is used to display images to a larger audience?
A
Printer
B
Projector
C
Scanner
D
External drive
Correct Answer: B
Projectors project images onto a screen.
Junior Certificate Examination
Digital Technologies
Q334.
What is the first step in troubleshooting a computer that won't start?
A
Check the power cable connection
B
Replace the RAM
C
Install new software
D
Update the operating system
Correct Answer: A
Ensuring power supply is connected is the initial diagnostic step.
Junior Certificate Examination
Digital Technologies
Q335.
Which of the following best describes a database report?
A
A form for entering data
B
A printed or digital summary of data
C
A query that retrieves data
D
A backup file
Correct Answer: B
Reports present data in a formatted manner for review.
Junior Certificate Examination
Digital Technologies
Q336.
In spreadsheet terminology, what does "absolute reference" mean?
A
Reference that changes when copied
B
Reference that never changes when copied
C
Reference that is relative to the column only
D
Reference that is relative to the row only
Correct Answer: B
Absolute references ($A$1) stay constant when copied.
Junior Certificate Examination
Digital Technologies
Q337.
Which of the following is a type of database component?
A
Query
B
CPU
C
Hard drive
D
RAM
Correct Answer: A
Queries are components that retrieve data from tables.
Junior Certificate Examination
Digital Technologies
Q338.
What is the primary function of a database form?
A
Display data in a table
B
Enter and edit data
C
Run complex calculations
D
Backup data
Correct Answer: B
Forms provide an interface for data entry.
Junior Certificate Examination
Digital Technologies
Q339.
Which of these is a common backup method using external storage?
A
Cloud backup
B
USB flash drive backup
C
Printing documents
D
Emailing files to oneself
Correct Answer: B
USB flash drives are commonly used for physical backups.
Junior Certificate Examination
Digital Technologies
Q340.
Which of the following is a correct way to write a formula that checks if a value is greater than 10 and returns "Yes" or "No"?
A
=IF(A1>10, "Yes", "No")
B
=IF(A1>10, "Yes" "No")
C
=IF(A1>10, Yes, No)
D
=IF(A1>10, "Yes", "No", "Maybe")
Correct Answer: A
The IF syntax requires a condition, value if true, value if false.
Junior Certificate Examination
Digital Technologies
Q341.
In a database, which component is used to display data in a printable format?
A
Table
B
Form
C
Report
D
Query
Correct Answer: C
Reports format data for printing or display.
Junior Certificate Examination
Digital Technologies
Q342.
What does "cloud storage" refer to?
A
Storing data on a local hard drive
B
Storing data on a remote server accessed via the internet
C
Storing data on a USB drive
D
Storing data on a CD-ROM
Correct Answer: B
Cloud storage uses remote servers accessible over the internet.
Junior Certificate Examination
Digital Technologies
Q343.
Which of the following is a type of computer hardware repair?
A
Installing a new operating system
B
Replacing a faulty RAM module
C
Updating a web browser
D
Adding a new user account
Correct Answer: B
Replacing RAM is a common hardware repair task.
Junior Certificate Examination
Digital Technologies
Q344.
What is the function of a firewall in cybersecurity?
A
To store data permanently
B
To block unauthorized network access
C
To process calculations
D
To display graphics
Correct Answer: B
Firewalls monitor and filter network traffic to prevent unauthorized access.
Junior Certificate Examination
Digital Technologies
Q345.
Which of the following is an example of a protective measure against phishing?
A
Clicking on unknown email links
B
Verifying sender's email address before opening attachments
C
Disabling antivirus software
D
Ignoring security updates
Correct Answer: B
Checking the sender helps prevent phishing attacks.
Junior Certificate Examination
Digital Technologies
Q346.
In spreadsheet functions, what does the AVERAGEIF function do?
A
Calculates the average of all cells in a range
B
Calculates the average of cells that meet a specified condition
C
Counts the number of cells that meet a condition
D
Sums cells that meet a condition
Correct Answer: B
AVERAGEIF averages only the cells that satisfy the condition.
Junior Certificate Examination
Digital Technologies
Q347.
Which of these is a typical symptom of a faulty hard drive?
A
Random reboots
B
Slow data transfer speeds
C
Overheating CPU
D
All of the above
Correct Answer: B
A failing hard drive often shows reduced transfer speeds.
Junior Certificate Examination
Digital Technologies
Q348.
Which of the following is a common hardware component for storing data temporarily?
Correct Answer: C
RAM temporarily holds data for quick access by the CPU.
Junior Certificate Examination
Digital Technologies
Q349.
What does the term "projector" refer to in computer peripherals?
A
A device that prints documents
B
A device that scans documents
C
A device that projects images onto a screen
D
A device that stores data externally
Correct Answer: C
Projectors display images onto a larger surface.
Junior Certificate Examination
Mathematics
Q350.
Which of the following numbers is the greatest?
A
2,345,678
B
23,456,78
C
234,567,8
D
234,567,80
Correct Answer: A
2,345,678 has the most digits and the highest place values compared to the others.