IC3 Digital Literacy Certification — Questions and Answers

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

To replace deleted paragraphs
To find and replace missing files on the computer
To find spelling errors only
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 2: What are best practices for designing slides with data visualizations?

Use clear charts with limited data points, descriptive titles, and highlight the key takeaway (Correct answer)
Only use tables, never charts or graphs
Always use 3D charts for visual appeal
Include as much data as possible on each slide

Correct answer: Use clear charts with limited data points, descriptive titles, and highlight the key takeaway

Effective data slides use appropriate chart types, limit data points, include titles that state the key insight, and use color to highlight important data.

Question 3: What type of port is commonly used to connect external displays to a computer?

USB-A
Audio jack
HDMI (Correct answer)
Ethernet

Correct answer: HDMI

HDMI (High-Definition Multimedia Interface) is a standard port used to transmit both high-definition video and audio signals from a computer to an external display.

Question 4: A student creating a presentation for a school project finds a compelling photograph online. To ethically use this image, which of the following is the BEST course of action?

Take a screenshot of the image to avoid direct downloading.
Copy the image and use it, assuming it's okay for educational purposes.
Find an image with a Creative Commons license that permits reuse or is in the public domain. (Correct answer)
Use the image but include the photographer's name somewhere in the presentation.

Correct answer: Find an image with a Creative Commons license that permits reuse or is in the public domain.

Simply copying an image likely infringes on the creator's copyright. While citing the photographer is good practice, it does not grant permission to use a copyrighted work. The most ethically sound and legally safe approach is to find an image that is explicitly licensed for reuse, such as those under a Creative Commons license or works that are in the public domain.

Question 5: What is an echo chamber in online information consumption?

A sound effect used in podcasts
A feature that amplifies audio in video calls
A type of online music streaming service
An environment where people only encounter opinions and information that reinforce their existing beliefs (Correct answer)

Correct answer: An environment where people only encounter opinions and information that reinforce their existing beliefs

An echo chamber is an information environment where users are primarily exposed to opinions that mirror their own, reinforced by social connections and algorithmic curation.

Question 6: What is the purpose of a device driver?

To provide internet connectivity
To increase the speed of the CPU
To physically install hardware components
To allow the operating system to communicate with hardware devices (Correct answer)

Correct answer: To allow the operating system to communicate with hardware devices

Device drivers are software that act as translators between the operating system and hardware devices, enabling the OS to send and receive data from peripherals.

Question 7: In a database table, what does the term 'data type' refer to?

The order in which records are displayed
The name assigned to a table
The format that defines what kind of data a field can store (Correct answer)
The relationship between two tables

Correct answer: The format that defines what kind of data a field can store

A data type specifies what kind of data a field can hold — such as text, number, date, or Boolean — and determines how the data is stored and used.

Question 8: What is Presenter View and what advantages does it offer?

A dual-screen mode showing slides to the audience while displaying notes, next slide preview, and tools to the presenter (Correct answer)
A mode for editing slides
A view that shows the presentation on a projector
A feature that records the presentation

Correct answer: A dual-screen mode showing slides to the audience while displaying notes, next slide preview, and tools to the presenter

Presenter View uses a dual-screen setup to show the audience only the slides while the presenter sees notes, next slide preview, timer, and navigation controls.

Question 9: In a word processor, what is the purpose of styles?

To insert page numbers
To add clip art to documents
To apply consistent, predefined formatting to text elements (Correct answer)
To check spelling and grammar

Correct answer: To apply consistent, predefined formatting to text elements

Styles are predefined sets of formatting attributes (font, size, color, spacing) that can be applied to text, ensuring consistency and enabling quick formatting changes throughout a document.

Question 10: What is the ethical concern with sharing someone else's personal information online without their consent?

It slows down internet speeds
There are no concerns if the information is factual
It uses too much bandwidth
It violates their privacy and can lead to identity theft or harassment (Correct answer)

Correct answer: It violates their privacy and can lead to identity theft or harassment

Sharing personal information without consent violates privacy rights and can expose individuals to identity theft, stalking, harassment, discrimination, or other harmful consequences.

Question 11: What is the purpose of version history in collaborative tools?

To count how many users accessed the document
To restrict access to certain users
To track all changes over time and allow restoration of previous document states (Correct answer)
To compress the document file size

Correct answer: To track all changes over time and allow restoration of previous document states

Version history records all changes made to a document over time, showing who made each change and when, and allows users to view or restore any previous version.

Question 12: What is the advantage of using a relational database over a flat file database?

Relational databases can only store text data
Relational databases eliminate data redundancy by linking related tables (Correct answer)
Flat file databases support more users simultaneously
Flat file databases are faster for all types of queries

Correct answer: Relational databases eliminate data redundancy by linking related tables

Relational databases store data across multiple linked tables, avoiding repetition of the same information and making updates consistent across all related records.

Question 13: What is the difference between a relative, absolute, and mixed cell reference?

There is no functional difference between them
Relative references adjust when copied, absolute references stay fixed, and mixed references lock either the row or column (Correct answer)
Absolute references are faster to calculate
Relative references are for text, absolute for numbers

Correct answer: Relative references adjust when copied, absolute references stay fixed, and mixed references lock either the row or column

Relative references (A1) adjust when copied, absolute references ($A$1) remain fixed, and mixed references ($A1 or A$1) lock only the column or row.

Question 14: Which of the following is a key benefit of using 'Styles' (e.g., Heading 1, Normal) to format a document instead of applying formatting manually to each section?

It automatically checks for spelling and grammar errors.
It allows for quick, consistent formatting changes across the entire document. (Correct answer)
It encrypts the document to prevent unauthorized access.
It reduces the document's file size.

Correct answer: It allows for quick, consistent formatting changes across the entire document.

Using styles allows you to apply a pre-defined set of formatting options (font, size, color, spacing) to text. If you decide to change the formatting for a style, such as 'Heading 1', every instance of that style in the document will update automatically, ensuring consistency and saving time.

Question 15: Why is it important to use a professional email format in workplace communication?

Professional formatting makes emails send faster
It is required by internet standards
Professional emails use less storage space
It conveys professionalism, ensures clarity, and reflects well on the sender and organization (Correct answer)

Correct answer: It conveys professionalism, ensures clarity, and reflects well on the sender and organization

Professional email formatting with clear subject lines, proper greetings, concise content, and appropriate signatures conveys competence and ensures effective workplace communication.

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

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
The technical error introduced when video footage is compressed for streaming
The difference in reading level between tabloid and broadsheet newspapers

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 17: Which data type should be used to store a person's age in a database field?

Number (Correct answer)
Hyperlink
Text
Date/Time

Correct answer: Number

Age is a numeric value, so the Number data type is appropriate, allowing mathematical operations like averaging ages.

Question 18: What is a wiki and how is it used for team knowledge management?

A collaborative website where team members can create, edit, and organize shared knowledge pages (Correct answer)
A file compression tool
A type of search engine
A secure messaging application

Correct answer: A collaborative website where team members can create, edit, and organize shared knowledge pages

A wiki is a collaborative knowledge base where team members can create, edit, and organize interconnected pages of information.

Question 19: What is malware?

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

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 20: What is a watermark and when would you use one in a document?

A decorative border around the page
A bookmark for saving your reading position
A type of font style
A faded background text or image that appears behind document content to indicate status or ownership (Correct answer)

Correct answer: A faded background text or image that appears behind document content to indicate status or ownership

A watermark is a semi-transparent text or image behind the main content, commonly used to mark documents as Draft, Confidential, or to display a logo.

Question 21: A company wants to ensure that employees only have access to the files and applications necessary for their specific job roles. Which of the following operating system features would an administrator use to accomplish this?

Device driver installation
System restore points
Disk partitioning
User account control and permissions (Correct answer)

Correct answer: User account control and permissions

User account control and permissions are security features built into operating systems to manage what resources a user can access. Administrators can create standard user accounts with limited privileges for regular employees, preventing them from accessing sensitive files or installing unauthorized software, thereby enforcing the principle of least privilege.

Question 22: Which operating system is developed and maintained by Apple Inc. for its Mac computers?

macOS (Correct answer)
Windows
Android
Linux

Correct answer: macOS

macOS is Apple's proprietary operating system designed exclusively for Mac desktop and laptop computers.

Question 23: Which of the following best describes 'line spacing' in a word processor?

The number of columns on a page
The amount of vertical space between lines of text in a paragraph (Correct answer)
The margin between the text and the edge of the page
The space between individual characters within a word

Correct answer: The amount of vertical space between lines of text in a paragraph

Line spacing controls the vertical distance between consecutive lines of text within a paragraph, commonly set to single, 1.5, or double spacing for readability.

Question 24: What is the role of cache memory in a computer system?

It backs up data to an external drive
It permanently stores user files
It provides ultra-fast temporary storage for frequently accessed data to speed up processing (Correct answer)
It manages internet browsing history

Correct answer: It provides ultra-fast temporary storage for frequently accessed data to speed up processing

Cache memory is a small, extremely fast memory located close to or within the CPU that stores copies of frequently accessed data to reduce the time needed to fetch them from slower main memory.

Question 25: A project manager shares a draft of a proposal with several stakeholders using an online document collaboration tool. They want the stakeholders to be able to provide feedback and suggestions without directly altering the original content. Which sharing permission level is the MOST appropriate to assign?

Owner
Viewer
Commenter (Correct answer)
Editor

Correct answer: Commenter

The 'Commenter' role allows users to view the document and add comments or suggestions, but they cannot directly edit the main body of the text. This meets the requirement of getting feedback without changing the original content. 'Viewer' would not allow feedback, 'Editor' would allow direct changes, and 'Owner' grants full control.

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

RAM
GPU (Correct answer)
Power supply
CPU

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 27: Which word processing feature allows you to automatically correct common spelling mistakes as you type?

Spell Check
AutoFormat
AutoCorrect (Correct answer)
Grammar Check

Correct answer: AutoCorrect

AutoCorrect automatically fixes common typos and misspellings in real time as you type, whereas Spell Check is a manual review tool you run after writing.

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

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

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 29: Which file format is most universally compatible for sharing a presentation that others cannot easily edit?

PPTX
ODP
DOCX
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 30: What is the purpose of the CONCATENATE or CONCAT function?

It splits text in a cell into separate cells
It counts the number of characters in a cell
It calculates the total of a range of cells
It joins two or more text strings together into one combined string (Correct answer)

Correct answer: It joins two or more text strings together into one combined string

CONCAT joins multiple text strings into a single string, useful for combining names or building descriptions from separate data fields.

Question 31: What is the primary purpose of assigning roles such as 'Viewer,' 'Commenter,' and 'Editor' in a shared online document?

To control what actions each collaborator is permitted to perform (Correct answer)
To schedule when the document will be automatically deleted
To track how many people have opened the file
To set the document's font and formatting defaults

Correct answer: To control what actions each collaborator is permitted to perform

Permission roles limit what each user can do — viewers can only read, commenters can add feedback, and editors can modify content — protecting document integrity.

Question 32: Which of the following best describes a 'field' in a database table?

A query used to search for data
A single category of information stored in a column (Correct answer)
A report generated from the database
A row containing all data for one item

Correct answer: A single category of information stored in a column

A field is a single category of information represented by a column in a database table, such as 'Last Name' or 'Phone Number'.

Question 33: Which one of the following operating systems runs on mainframes?

Windows
UNIX (Correct answer)
MAC OS
DOS

Correct answer: UNIX

Explanation: <br> UNIX is the correct answer because it is an operating system that is commonly used on mainframe computers. Mainframes are large, powerful computers that are used by organizations for critical applications and large-scale data processing. UNIX is known for its stability, security, and scalability, making it a popular choice for mainframe systems. It provides robust features and capabilities that are necessary for handling the complex and demanding requirements of mainframe computing.

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

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

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 35: What is ransomware and how can you protect against it?

An antivirus program
A tool for recovering lost passwords
Software that speeds up your computer for a fee
Malware that encrypts files and demands payment for the decryption key (Correct answer)

Correct answer: Malware that encrypts files and demands payment for the decryption key

Ransomware encrypts a victim's files or locks their system, then demands payment for the decryption key.

Question 36: What is a macro in spreadsheet software?

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

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 37: What does the IF function do in a spreadsheet?

It imports data from another file
It inserts an image into a cell
It formats cells with different colors
It performs a logical test and returns one value if true and another if false (Correct answer)

Correct answer: It performs a logical test and returns one value if true and another if false

The IF function evaluates a logical condition and returns one value when true and a different value when false.

Question 38: What is the responsibility of a digital citizen regarding accessibility?

Ensuring digital content and communications are inclusive and accessible to people with disabilities (Correct answer)
Only communicating with people who have similar abilities
Avoiding the use of technology altogether
Only using accessible websites themselves

Correct answer: Ensuring digital content and communications are inclusive and accessible to people with disabilities

Responsible digital citizens consider accessibility by creating inclusive content, using alt text for images, ensuring proper contrast, and supporting assistive technology compatibility.

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

Captions for embedded videos
Comments added by audience members
Hidden notes visible only to the presenter that serve as prompts and additional details during delivery (Correct answer)
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 40: What is conditional formatting in a spreadsheet?

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

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 41: What drive usually represents the main hard disk drive?

C (Correct answer)
A
H
F

Correct answer: C

Explanation: <br> The letter "C" is commonly used to represent the main hard disk drive in a computer system. This convention has been in place for many years and is widely recognized by computer users and operating systems. Other drive letters, such as A and F, are typically used for floppy disk drives or additional storage devices.

Question 42: How do search engine algorithms determine the order of search results?

Results are ordered alphabetically
Only paid advertisements appear in results
Results are displayed randomly
Algorithms consider relevance, authority, user behavior, content quality, and hundreds of other ranking factors (Correct answer)

Correct answer: Algorithms consider relevance, authority, user behavior, content quality, and hundreds of other ranking factors

Search engines use complex algorithms that evaluate hundreds of factors including keyword relevance, website authority, content quality, and user engagement metrics.

Question 43: You are at a coffee shop using their public Wi-Fi network. Which of the following activities should you AVOID doing?

Checking the local weather forecast.
Browsing general news websites.
Streaming a public video from a popular service.
Accessing your online banking account. (Correct answer)

Correct answer: Accessing your online banking account.

Public Wi-Fi networks are often unencrypted and not secure. Malicious actors on the same network could potentially intercept the data you send and receive (a 'Man-in-the-Middle' attack). Therefore, you should avoid transmitting any sensitive personal or financial information, like online banking credentials.

Question 44: What is data validation in a spreadsheet?

A formula for checking password strength
Rules that restrict the type or range of data that can be entered into specific cells (Correct answer)
A process of backing up spreadsheet data
A method for validating internet connections

Correct answer: Rules that restrict the type or range of data that can be entered into specific cells

Data validation sets rules on cells that restrict what data can be entered, such as numbers within a range, dates, or items from a dropdown list.

Question 45: What are cookies in web browsing and what privacy concerns do they raise?

Small programs that speed up your computer
Advertisements displayed on web pages
Viruses downloaded from websites
Small data files stored by websites to remember user preferences, sessions, and track browsing behavior (Correct answer)

Correct answer: Small data files stored by websites to remember user preferences, sessions, and track browsing behavior

Browser cookies are small text files stored on your device by websites to maintain sessions, remember preferences, and track browsing behavior across sites.

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