IC3 Digital Literacy Certification — Questions and Answers

Question 1: What is malware?

Any software intentionally designed to cause damage or unauthorized access to systems (Correct answer)
A browser extension that blocks advertisements
A type of hardware component that slows down your computer
An outdated operating system that is no longer supported

Correct answer: Any software intentionally designed to cause damage or unauthorized access to systems

Malware (malicious software) is a broad term covering any software designed to harm, exploit, or gain unauthorized access to computer systems, including viruses, trojans, spyware, and ransomware.

Question 2: What are the signs of a secure website when entering personal information?

HTTPS in the URL, a padlock icon, valid SSL certificate, and a legitimate domain name (Correct answer)
The website loads quickly
The website has a lot of advertisements
The website has colorful graphics

Correct answer: HTTPS in the URL, a padlock icon, valid SSL certificate, and a legitimate domain name

Secure websites display HTTPS, show a padlock icon, have a valid SSL/TLS certificate, and use a legitimate domain name matching the expected organization.

Question 3: What is the difference between primary and secondary sources?

Secondary sources are always written by experts
There is no meaningful difference
Primary sources are always more accurate
Primary sources are original firsthand accounts while secondary sources analyze or interpret primary sources (Correct answer)

Correct answer: Primary sources are original firsthand accounts while secondary sources analyze or interpret primary sources

Primary sources are original, firsthand materials created during the period being studied, while secondary sources analyze, interpret, or summarize primary sources.

Question 4: What does 'Creative Commons' licensing allow content creators to do?

Prevent anyone from ever accessing their content
Sell their content exclusively to one buyer
Automatically copyright all online content
Specify how others may use, share, and modify their work (Correct answer)

Correct answer: Specify how others may use, share, and modify their work

Creative Commons licenses let creators specify permissions for their work, ranging from allowing free use with attribution to restricting commercial use or derivative works.

Question 5: What is the difference between SSD and HDD storage?

SSDs use flash memory with no moving parts while HDDs use spinning magnetic disks (Correct answer)
SSDs are always larger in capacity than HDDs
There is no functional difference between them
SSDs use magnetic platters while HDDs use flash memory

Correct answer: SSDs use flash memory with no moving parts while HDDs use spinning magnetic disks

SSDs store data on flash memory chips with no moving parts, offering faster speeds and greater durability. HDDs use spinning magnetic platters read by a mechanical arm.

Question 6: How do you insert and format images in a word processing document?

Images cannot be inserted into word processors
Images can only be pasted from the clipboard
Images must be placed in headers or footers only
Insert the image, set text wrapping to control layout, resize as needed, and add alt text for accessibility (Correct answer)

Correct answer: Insert the image, set text wrapping to control layout, resize as needed, and add alt text for accessibility

Images are inserted via the Insert menu, and formatting includes text wrapping style, resizing, positioning, effects, and alt text.

Question 7: Which of the following is the most reliable indicator that a website is a credible source of information?

The website has a modern, visually appealing design
The content cites verifiable sources and clearly identifies its authors and their credentials (Correct answer)
The website uses a .com domain
The website ranks first in a Google search result

Correct answer: The content cites verifiable sources and clearly identifies its authors and their credentials

Credible sources identify their authors with verifiable credentials and support claims with cited, checkable references. Domain type and design can be mimicked by anyone, and search ranking reflects SEO, not accuracy.

Question 8: What is the primary purpose of using a clear and concise subject line in a professional email?

To replace the need for a formal greeting
To allow the recipient to quickly understand the email's purpose and priority (Correct answer)
To automatically sort the email into a specific folder
To serve as the official title of the attached document

Correct answer: To allow the recipient to quickly understand the email's purpose and priority

A clear and concise subject line is crucial for effective email communication as it summarizes the email's content, helping the recipient prioritize their inbox and understand the message's purpose before even opening it.

Question 9: What is screen sharing and when is it useful in collaboration?

Duplicating your display to a second monitor
Sharing your screen's brightness settings
Sharing screenshots via email
Broadcasting your computer screen to others during a virtual meeting for demonstrations or collaboration (Correct answer)

Correct answer: Broadcasting your computer screen to others during a virtual meeting for demonstrations or collaboration

Screen sharing broadcasts your computer screen to other participants during a virtual meeting, enabling live demonstrations, collaborative troubleshooting, and presentations.

Question 10: What does the 'Slide Master' feature in presentation software primarily control?

The animation speed of slide transitions
The consistent fonts, colors, and layouts applied across all slides (Correct answer)
The order in which slides appear during a slideshow
The number of slides allowed in a presentation

Correct answer: The consistent fonts, colors, and layouts applied across all slides

The Slide Master is a top-level slide that controls the default formatting — fonts, colors, background, and placeholder positions — applied consistently to all slides in the presentation.

Question 11: What is conditional formatting in a spreadsheet?

Formatting that only appears when the document is printed
Rules that automatically change cell appearance based on the cell's value (Correct answer)
A way to password-protect specific cells
A formula that returns TRUE or FALSE

Correct answer: Rules that automatically change cell appearance based on the cell's value

Conditional formatting applies visual formatting like colors, icons, or data bars to cells based on rules you define, making it easy to highlight important data patterns.

Question 12: What is the purpose of grouping objects on a slide?

To combine multiple objects into a single unit that can be moved, resized, and formatted together (Correct answer)
To compress the file size of the presentation
To delete multiple objects at once
To add animations to all objects simultaneously

Correct answer: To combine multiple objects into a single unit that can be moved, resized, and formatted together

Grouping combines multiple objects into a single unit that maintains their relative positions and can be moved, resized, and formatted as one.

Question 13: Which file format is most universally compatible for sharing a presentation that others cannot easily edit?

ODP
DOCX
PPTX
PDF (Correct answer)

Correct answer: PDF

Saving a presentation as a PDF preserves its layout and formatting across all devices and operating systems while preventing easy editing, making it the best choice for distribution.

Question 14: What does the VLOOKUP function do in a spreadsheet?

Validates that data entries are correct
Searches for a value in the first column of a range and returns a value from another column (Correct answer)
Counts cells that contain text
Converts vertical data to horizontal layout

Correct answer: Searches for a value in the first column of a range and returns a value from another column

VLOOKUP searches for a specified value in the leftmost column of a table range and returns a corresponding value from a specified column in the same row.

Question 15: What is the purpose of 'Find and Replace' in a word processor?

To find spelling errors only
To replace deleted paragraphs
To find and replace missing files on the computer
To search for specific text and optionally replace it with different text throughout the document (Correct answer)

Correct answer: To search for specific text and optionally replace it with different text throughout the document

Find and Replace searches the entire document for specified text, formatting, or special characters and can replace all instances at once.

Question 16: What is disk partitioning and why might you create multiple partitions?

Partitioning physically divides the hard drive into pieces
Partitioning logically divides a storage drive into separate sections that act as independent drives (Correct answer)
Partitioning is only possible on SSDs
Partitioning is the same as formatting

Correct answer: Partitioning logically divides a storage drive into separate sections that act as independent drives

Disk partitioning divides a single physical storage drive into multiple logical sections, each functioning as a separate drive.

Question 17: You are creating a multi-page report and want the page number to appear in the same location at the bottom of every page. Which feature should you use to accomplish this?

Footer (Correct answer)
Endnote
Text Box
Footnote

Correct answer: Footer

A footer is a section of the document that appears in the bottom margin and is repeated on every page. It is the correct place to insert elements like page numbers, document titles, or dates that you want to be consistent throughout the document.

Question 18: What is the purpose of a database Report object in Microsoft Access?

To establish relationships between tables
To display and print data in a formatted, organized layout (Correct answer)
To import data from external sources
To run automated macros on data

Correct answer: To display and print data in a formatted, organized layout

Reports in Access format database data for printing or sharing, presenting information in a professional, readable layout such as summaries or invoices.

Question 19: What are speaker notes in presentation software and how should they be used?

Comments added by audience members
Hidden notes visible only to the presenter that serve as prompts and additional details during delivery (Correct answer)
Captions for embedded videos
Text displayed on the presentation screen for the audience

Correct answer: Hidden notes visible only to the presenter that serve as prompts and additional details during delivery

Speaker notes are text added below each slide that are visible only to the presenter during delivery, serving as prompts and talking points.

Question 20: What is the role of collaboration platforms in modern digital communication?

They replace email entirely
They are only useful for large corporations
They integrate messaging, file sharing, video conferencing, and project management into unified workspaces (Correct answer)
They only serve as file storage systems

Correct answer: They integrate messaging, file sharing, video conferencing, and project management into unified workspaces

Collaboration platforms like Microsoft Teams, Slack, and Google Workspace integrate multiple communication tools and productivity features into one environment.

Question 21: You receive an email with the subject "Urgent: Your Account is Suspended!" from what appears to be your bank. The email asks you to click a link and enter your username and password to reactivate your account. Which element of this scenario is the BIGGEST indicator of a potential phishing attempt?

The email was sent outside of normal business hours.
The email asks for sensitive information like a password via a link. (Correct answer)
The bank is communicating with you via email.
The subject line creates a sense of urgency.

Correct answer: The email asks for sensitive information like a password via a link.

Legitimate organizations, especially banks, will almost never ask you to provide sensitive information like your password by clicking a link in an email. While creating a sense of urgency is a common tactic, the direct request for credentials via a link is the most definitive red flag of a phishing scam.

Question 22: In a spreadsheet application, what does the dollar sign ($) indicate when used in a cell reference like `$A$1`?

The cell contains currency data.
The formula in the cell has an error.
The cell is locked and cannot be edited.
The cell reference is absolute and will not change when copied. (Correct answer)

Correct answer: The cell reference is absolute and will not change when copied.

The dollar sign ($) creates an absolute reference. When a formula containing an absolute reference like `$A$1` is copied and pasted to other cells, the reference to cell A1 will not change. A relative reference (like A1) would change based on the new location.

Question 23: What happens when you delete a record from a database?

The record is automatically archived to another table
The record is hidden but still counted in reports
The record is moved to a recycle bin and can be restored anytime
The record's data is permanently removed from the table (Correct answer)

Correct answer: The record's data is permanently removed from the table

Deleting a database record permanently removes that row's data from the table; unlike the OS recycle bin, database deletes are typically irreversible without a backup.

Question 24: While participating in an online community, a user begins receiving repeated, hostile, and insulting messages from another player. What is the MOST appropriate first step to take in this situation?

Immediately respond to the messages with an equally aggressive tone.
Post the messages publicly on social media to expose the other player.
Block the other user and report their behavior to the platform's moderators. (Correct answer)
Delete your account and stop participating in the community to avoid contact.

Correct answer: Block the other user and report their behavior to the platform's moderators.

Engaging with a cyberbully or publicizing the conflict can escalate the situation. The most effective and recommended first step is to use the platform's built-in tools to block the user and report the harassment to administrators, who can take appropriate action.

Question 25: What happens when you use an absolute cell reference (e.g., $A$1) instead of a relative reference in a formula?

The formula only works on the first row of the spreadsheet
The cell displays a dollar amount
The cell reference updates automatically when the formula is copied to another cell
The cell reference stays fixed and does not change when the formula is copied (Correct answer)

Correct answer: The cell reference stays fixed and does not change when the formula is copied

An absolute cell reference locks the row and column with dollar signs ($), so the reference points to the same cell regardless of where the formula is copied. A relative reference, by contrast, shifts automatically based on the formula's new position.

Question 26: When saving a presentation to be viewed on a wide variety of devices, ensuring that the layout and fonts cannot be easily edited by the recipient, which file format is the MOST suitable choice?

.ODP
.POTX
.PDF (Correct answer)
.PPTX

Correct answer: .PDF

Saving a presentation as a PDF (Portable Document Format) preserves the formatting, fonts, and layout, making it universally viewable across different operating systems and devices. It is also a non-editable format by default, which protects the content from accidental changes.

Question 27: What are the best practices for scheduling and running effective virtual meetings?

Set clear agendas, respect time zones, keep meetings focused, and share action items afterward (Correct answer)
Virtual meetings should always last at least two hours
Always keep cameras off to save bandwidth
Only the meeting organizer should speak

Correct answer: Set clear agendas, respect time zones, keep meetings focused, and share action items afterward

Effective virtual meetings require preparation (clear agenda), structure (time management, focused discussion), and follow-up (documented decisions and action items).

Question 28: What does the term 'virtual memory' refer to in an operating system?

A dedicated graphics memory card
Cloud storage used to extend system memory
RAM installed on the motherboard
A portion of the hard drive used as additional RAM when physical RAM is full (Correct answer)

Correct answer: A portion of the hard drive used as additional RAM when physical RAM is full

Virtual memory allows the OS to use hard drive space as an extension of RAM, enabling the system to run more programs than physical memory alone would allow, though it is slower than actual RAM.

Question 29: How do you manage startup programs to improve boot time?

Increase the amount of RAM
Reinstall the operating system
Delete all programs from the computer
Disable unnecessary programs from automatically launching at startup through Task Manager or System Preferences (Correct answer)

Correct answer: Disable unnecessary programs from automatically launching at startup through Task Manager or System Preferences

Disabling non-essential startup programs reduces the number of applications loading during boot, improving startup speed and system responsiveness.

Question 30: Which Windows utility allows you to view and end processes that are consuming too many system resources?

Task Manager (Correct answer)
Disk Management
Control Panel
Device Manager

Correct answer: Task Manager

Task Manager provides a real-time view of running processes, CPU and memory usage, and allows users to force-quit unresponsive applications or resource-heavy processes.

Question 31: What is the function of the Windows Registry?

A database of all websites you have visited
A hierarchical database that stores configuration settings for the OS, hardware, applications, and user preferences (Correct answer)
A list of all files on the hard drive
A backup system for important documents

Correct answer: A hierarchical database that stores configuration settings for the OS, hardware, applications, and user preferences

The Windows Registry is a centralized hierarchical database that stores low-level configuration settings for the operating system, hardware, applications, and user preferences.

Question 32: What is a macro in spreadsheet software?

A type of chart
A large-format print setting
A keyboard shortcut for copy and paste
A recorded or programmed sequence of actions that automates repetitive tasks (Correct answer)

Correct answer: A recorded or programmed sequence of actions that automates repetitive tasks

A macro is a set of recorded or programmed instructions that automates repetitive tasks, saving time and reducing manual errors.

Question 33: What is the Track Changes feature and how is it used for document collaboration?

It records all edits made to a document so reviewers can see, accept, or reject each change (Correct answer)
It tracks how long you spend editing a document
It tracks the location where the document was last saved
It changes the document's file format

Correct answer: It records all edits made to a document so reviewers can see, accept, or reject each change

Track Changes records all insertions, deletions, and formatting modifications with colored markup so editors can review each change.

Question 34: What does 'media bias' mean when applied to news sources?

The difference in reading level between tabloid and broadsheet newspapers
The technical error introduced when video footage is compressed for streaming
A consistent slant or perspective in how news is selected, framed, or presented, which can influence audience perception (Correct answer)
The tendency of media outlets to prefer stories with images over text-only stories

Correct answer: A consistent slant or perspective in how news is selected, framed, or presented, which can influence audience perception

Media bias refers to the way a news organization's editorial choices — including which stories to cover, which facts to emphasize, and the language used — can reflect a particular political, cultural, or commercial viewpoint, shaping how audiences interpret events.

Question 35: What is two-factor authentication (2FA) and why is it recommended?

Having two administrators for one account
Using two different passwords for the same account
Logging into two devices simultaneously
Requiring two different forms of verification to prove your identity when logging in (Correct answer)

Correct answer: Requiring two different forms of verification to prove your identity when logging in

Two-factor authentication requires a second verification method beyond your password, such as a text code or authenticator app, significantly reducing unauthorized access risk.

Question 36: What is the purpose of the VLOOKUP function in a spreadsheet?

To merge two separate spreadsheet files into one
To count how many cells in a range contain text
To sort a column of values in ascending order
To search for a value in the leftmost column of a table and return a corresponding value from another column (Correct answer)

Correct answer: To search for a value in the leftmost column of a table and return a corresponding value from another column

VLOOKUP (Vertical Lookup) searches down the first column of a defined table range for a match, then returns a value from a column you specify to the right. It is commonly used to pull related data from large reference tables.

Question 37: Which one of the following is NOT an e-mail program?

Eudora
Microsoft Outlook
Lotus CC
Mozilla Firefox (Correct answer)

Correct answer: Mozilla Firefox

Explanation: <br> Mozilla Firefox is a web browser, not an email program. While it does have some email capabilities, such as the ability to access webmail services, it is primarily used for browsing the internet and does not have the full range of features that dedicated email programs like Microsoft Outlook, Eudora, and Lotus CC have.

Question 38: Which computer component is responsible for rendering images and video on a display?

RAM
CPU
Power supply
GPU (Correct answer)

Correct answer: GPU

The GPU (Graphics Processing Unit) is specifically designed to handle rendering images, video, and animations, offloading this work from the CPU.

Question 39: What is the principle of least privilege in cybersecurity?

Restricting internet access for all employees
Giving all users administrator access
Using the simplest possible passwords
Granting users only the minimum access rights necessary to perform their job functions (Correct answer)

Correct answer: Granting users only the minimum access rights necessary to perform their job functions

The principle of least privilege means granting users, applications, and systems only the minimum permissions necessary to perform their required tasks.

Question 40: Which of the following best describes a phishing attack?

A fraudulent attempt to obtain sensitive information by disguising as a trustworthy entity (Correct answer)
Software that monitors your keystrokes without your knowledge
An unauthorized person physically accessing your computer
A virus that encrypts your files and demands payment

Correct answer: A fraudulent attempt to obtain sensitive information by disguising as a trustworthy entity

Phishing attacks use deceptive emails, messages, or websites that impersonate legitimate organizations to trick users into revealing passwords, credit card numbers, or other sensitive data.

Question 41: How do you use the INDEX and MATCH functions together?

They are only used for formatting
INDEX returns a value from a range at a specified position, and MATCH finds that position, together enabling flexible lookups (Correct answer)
They create automatic indexes and match colors
They sort data alphabetically

Correct answer: INDEX returns a value from a range at a specified position, and MATCH finds that position, together enabling flexible lookups

INDEX returns a value from a specified position, while MATCH finds that position. Combined, they create a flexible alternative to VLOOKUP.

Question 42: What is the purpose of a 'master slide' in presentation software?

To export the presentation as a PDF
To add animations to every slide
To define consistent formatting and layout across all slides (Correct answer)
To create a backup of the presentation

Correct answer: To define consistent formatting and layout across all slides

A master slide sets the default fonts, colors, backgrounds, and placeholder positions that apply consistently across all slides in a presentation.

Question 43: When composing a professional email, what is the recommended practice regarding the subject line?

Write a clear, specific subject line that summarizes the email's purpose (Correct answer)
Leave it blank so the recipient is curious enough to open it
Write a vague subject like 'Hello' to keep it casual
Use all capital letters to make it stand out

Correct answer: Write a clear, specific subject line that summarizes the email's purpose

A clear and specific subject line helps the recipient immediately understand the email's purpose, prioritize it appropriately, and locate it easily later, which is essential in professional communication.

Question 44: What is the purpose of footnotes and endnotes in a document?

To insert page numbers
To add decorative elements to pages
To provide citations, references, or supplementary information without interrupting the main text flow (Correct answer)
To create a document outline

Correct answer: To provide citations, references, or supplementary information without interrupting the main text flow

Footnotes (at the bottom of the page) and endnotes (at the end of the document) provide citations and additional commentary without cluttering the main body.

Question 45: What is the purpose of an index in a database?

To speed up data retrieval and search operations (Correct answer)
To define the visual layout of a form
To restrict user access permissions
To list all tables in the database

Correct answer: To speed up data retrieval and search operations

An index stores a sorted reference to key field values, allowing the database engine to find matching records much faster than scanning every record.

IC3 Digital Literacy Certification

The IC3 Global Standard 6 certification validates foundational digital literacy skills across computing fundamentals, key applications, and online living.

Questions

50 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds