IC3 Digital Literacy Certification — Questions and Answers

Question 1: What is 'confirmation bias' and how does it affect information consumption?

The tendency to favor information that confirms existing beliefs while ignoring contradictory evidence (Correct answer)
A technical error in web browsers
A feature that confirms email delivery
A security setting in web browsers

Correct answer: The tendency to favor information that confirms existing beliefs while ignoring contradictory evidence

Confirmation bias leads people to seek, interpret, and remember information that supports their existing views while dismissing evidence that challenges them.

Question 2: A user wants to create a presentation but has limited design skills. Which feature of presentation software provides a pre-designed collection of layouts, colors, fonts, and effects to quickly create a professional-looking presentation?

Chart Tool
WordArt
Drawing Tools
Template (Correct answer)

Correct answer: Template

A template is a pre-designed file that includes layouts, formatting (like themes, fonts, and colors), and often some placeholder content. Using a template is an efficient way to start a new presentation with a consistent and professional design.

Question 3: What does the IF function do in a spreadsheet?

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

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 4: Which spreadsheet function calculates the arithmetic mean of a range of cells?

COUNT
MAX
SUM
AVERAGE (Correct answer)

Correct answer: AVERAGE

The AVERAGE function adds all values in the specified range and divides by the count of numeric entries to return the arithmetic mean.

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

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

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 6: You have a large spreadsheet with column headers in the first row. When you scroll down, these headers disappear, making it difficult to identify the data in each column. Which feature should you use to keep the headers visible while scrolling?

Filter Data
Conditional Formatting
Sort Data
Freeze Panes (Correct answer)

Correct answer: Freeze Panes

The Freeze Panes feature is specifically designed to lock specific rows or columns in place, so they remain visible on the screen as you scroll through the rest of the worksheet. This is ideal for keeping headers in view.

Question 7: Which of the following adds a visual effect to how one slide changes to the next during a presentation?

Transition (Correct answer)
Theme
Template
Animation

Correct answer: Transition

A slide transition is the visual effect that occurs when you move from one slide to the next during a presentation. Animations, on the other hand, apply to specific objects or text on a slide.

Question 8: What should you do if you suspect your online account has been compromised?

Immediately change your password, enable 2FA, review account activity, and notify the service provider (Correct answer)
Delete the account and create a new one using the same password
Wait to see if the situation resolves itself
Post about it on social media to warn others

Correct answer: Immediately change your password, enable 2FA, review account activity, and notify the service provider

If you suspect account compromise, immediately change your password, enable 2FA, review recent account activity, and contact the service provider.

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

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

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 10: How do you insert and format images in a word processing document?

Images can only be pasted from the clipboard
Images must be placed in headers or footers only
Images cannot be inserted into word processors
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 11: The feature that allows multiple users to be in the same online document at the same time and see each other's cursors and typed changes as they happen is known as:

Real-time co-authoring (Correct answer)
File sharing
Asynchronous editing
Version control

Correct answer: Real-time co-authoring

Real-time co-authoring (or simultaneous editing) is the specific term for the functionality where multiple collaborators can work within a document at the same time and view each other's contributions live. This is a hallmark of modern online office suites like Google Workspace and Microsoft 365.

Question 12: Which view in presentation software is best suited for adding and formatting text content on a single slide in detail?

Reading view
Presenter view
Normal view (Correct answer)
Slide Sorter view

Correct answer: Normal view

Normal view displays one slide at a time at full size alongside the slide panel and notes pane, making it the most practical view for editing and formatting individual slide content.

Question 13: Which of the following is considered a best practice for managing digital files on an operating system to ensure they are easy to find and retrieve?

Encrypting every file on the hard drive.
Saving all files in a single folder named 'Documents'.
Storing all files directly on the desktop for quick access.
Using a consistent and descriptive naming convention for files and folders. (Correct answer)

Correct answer: Using a consistent and descriptive naming convention for files and folders.

Using a logical, consistent, and descriptive naming convention for both files and folders is a fundamental best practice for effective file management. This makes it significantly easier for users to search for, identify, and retrieve the information they need without having to open multiple files.

Question 14: What does RAM stand for, and what is its primary function?

Read Access Memory — permanently stores programs
Read All Memory — backs up files automatically
Random Access Memory — temporarily stores data the CPU is actively using (Correct answer)
Rapid Application Memory — speeds up internet connections

Correct answer: Random Access Memory — temporarily stores data the CPU is actively using

RAM (Random Access Memory) is temporary working memory that the CPU uses to store data and programs currently in use.

Question 15: How do you effectively use animations in a presentation?

Use subtle, purposeful animations to reveal information sequentially and guide audience attention (Correct answer)
Animations should only be used for title slides
Add as many different animations as possible for maximum impact
Never use animations in professional presentations

Correct answer: Use subtle, purposeful animations to reveal information sequentially and guide audience attention

Effective animations are subtle, consistent, and serve a purpose: revealing information step by step or highlighting key points.

Question 16: An employee is setting up a new account for a critical work system. Which of the following passwords is the MOST secure?

M$p_4!wR*d_7k (Correct answer)
theirpet'sname
Password123
CompanyName2026!

Correct answer: M$p_4!wR*d_7k

This password is the strongest because it is long (over 12 characters) and includes a mix of uppercase letters, lowercase letters, numbers, and symbols, making it difficult to guess or crack. The other options are easily guessable, use common words, or follow predictable patterns.

Question 17: What is VoIP and how does it work?

Voice over Internet Protocol, which transmits voice calls over the internet instead of traditional phone lines (Correct answer)
A social media platform
A type of computer virus
A method of encrypting text messages

Correct answer: Voice over Internet Protocol, which transmits voice calls over the internet instead of traditional phone lines

VoIP converts voice into digital packets and transmits them over the internet, enabling voice calls through apps like Skype, Zoom, and Teams without traditional phone lines.

Question 18: When you buy a new computer, which of the following is most likely pre-installed on your computer?

An accounting program
The Operating System (Correct answer)
A spreadsheet program
A database program

Correct answer: The Operating System

Explanation: <br> When you buy a new computer, it is most likely pre-installed with the operating system. The operating system is the software that manages the computer's hardware and software resources, allowing other programs to run on the computer. It provides a user interface and enables the user to interact with the computer. Without an operating system, the computer would not be able to function properly and other programs like a database program, accounting program, or spreadsheet program would not be able to run. Therefore, the operating system is an essential component that is typically pre-installed on a new computer.

Question 19: What is the purpose of system restore points in Windows?

To backup personal files and photos
To increase available disk space
To update the operating system to the latest version
To save the current state of system files and settings so you can revert to them if problems occur (Correct answer)

Correct answer: To save the current state of system files and settings so you can revert to them if problems occur

System restore points capture the current state of Windows system files, drivers, and settings, allowing you to roll back if issues arise.

Question 20: A student is writing a research paper on the effects of climate change and finds an article on a website. The article claims that climate change is a hoax and is supported by several personal blog posts. Which of the following is the MOST important step the student should take to evaluate the credibility of this source?

Read the 'About Us' page to see if the authors seem passionate about the topic.
Check if the website has a professional-looking design.
Cross-reference the claims with reputable scientific sources, such as peer-reviewed journals or government agency reports. (Correct answer)
See how many times the article has been shared on social media.

Correct answer: Cross-reference the claims with reputable scientific sources, such as peer-reviewed journals or government agency reports.

The most reliable way to verify information is to cross-reference it with multiple, authoritative sources. Reputable sources like peer-reviewed journals, academic institutions, and government agencies (e.g., NASA, NOAA) base their findings on rigorous scientific research and data, making them ideal for fact-checking claims. Website design, social media popularity, and author passion are not reliable indicators of factual accuracy.

Question 21: What are best practices for designing slides with data visualizations?

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

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 22: What is the advantage of using a relational database over a flat file database?

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

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 23: Which of the following is considered an example of cyberbullying?

Playing a competitive online game against strangers
Sending a friend a funny meme they requested
Disagreeing with someone's opinion in a forum post
Posting a peer's embarrassing photo online to humiliate them (Correct answer)

Correct answer: Posting a peer's embarrassing photo online to humiliate them

Cyberbullying involves using digital technology to harass, humiliate, or harm another person; sharing embarrassing content about someone without consent is a clear example.

Question 24: Why is it important to check the publication date when evaluating an online article?

Search engines only index articles published within the last year
Information can become outdated, and an old article may no longer reflect the current state of knowledge or events (Correct answer)
A recent publication date guarantees the information is accurate
Older articles always contain more reliable statistics

Correct answer: Information can become outdated, and an old article may no longer reflect the current state of knowledge or events

Facts, statistics, laws, and scientific understanding change over time. An article that was accurate when written may now be misleading because newer data, events, or research have superseded it.

Question 25: When entering sensitive information, such as a credit card number, on a website, which of the following is the most important indicator that the connection is secure?

The website has a professional design and high-quality images.
The website's privacy policy is easy to find and read.
The website is listed at the top of a search engine result page.
The URL begins with "https" and shows a padlock icon. (Correct answer)

Correct answer: The URL begins with "https" and shows a padlock icon.

HTTPS (Hypertext Transfer Protocol Secure) indicates that the data transmitted between your browser and the website is encrypted. The padlock icon is a visual confirmation of this secure connection, which is crucial for protecting sensitive data from being intercepted.

Question 26: 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 27: What is the primary advantage of using BCC (Blind Carbon Copy) in email?

It makes the email arrive faster
It adds a read receipt to the email
It encrypts the email content
It hides recipient addresses from other recipients for privacy (Correct answer)

Correct answer: It hides recipient addresses from other recipients for privacy

BCC hides the email addresses of recipients from all other recipients, protecting their privacy and preventing reply-all situations in mass communications.

Question 28: When you freeze panes in a spreadsheet, what is the main benefit?

All cells outside the frozen area are locked so they cannot be edited
Formulas in frozen rows recalculate faster than those in unfrozen rows
The spreadsheet saves a snapshot of the current view for printing
Selected rows or columns remain visible on screen as you scroll through the rest of the data (Correct answer)

Correct answer: Selected rows or columns remain visible on screen as you scroll through the rest of the data

Freezing panes keeps specific rows (such as a header row) or columns (such as a label column) stationary on screen while you scroll through a large dataset, so you always know what each row or column represents.

Question 29: What is the function of a motherboard in a computer?

It serves as the main circuit board connecting all components (Correct answer)
It regulates the electrical current from the wall outlet
It provides wireless internet access
It stores all of the user's files

Correct answer: It serves as the main circuit board connecting all components

The motherboard is the main printed circuit board that connects and allows communication between all major components including the CPU, RAM, storage devices, and expansion cards.

Question 30: What is the advantage of using cloud-based storage (like Google Drive or OneDrive) compared to saving files only on a local hard drive?

Cloud storage is always faster to access than a local hard drive
Local hard drives automatically sync with the cloud without any setup
Files stored in the cloud can be accessed from any internet-connected device and are automatically backed up (Correct answer)
Cloud storage never requires an internet connection

Correct answer: Files stored in the cloud can be accessed from any internet-connected device and are automatically backed up

Cloud storage provides device-independent access and automatic backup, protecting files even if your local device is lost or damaged.

Question 31: What is the difference between a header and a footer in a document?

Headers are for titles only and footers are for images only
There is no functional difference between them
Headers appear at the top of each page and footers at the bottom, both containing repeating information (Correct answer)
Headers appear on odd pages and footers on even pages

Correct answer: Headers appear at the top of each page and footers at the bottom, both containing repeating information

Headers are areas at the top of each page and footers at the bottom that contain repeating information like page numbers, titles, and dates.

Question 32: What is the primary purpose of a website's Terms of Service (ToS) agreement?

To explain how to navigate the website's features
To outline the legal rules and conditions users must agree to when using the service (Correct answer)
To list the website's advertising partners
To provide technical support contact information

Correct answer: To outline the legal rules and conditions users must agree to when using the service

A Terms of Service agreement is a legal contract between the service provider and the user that defines acceptable use, user rights, and the provider's responsibilities.

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

The cell displays a dollar amount
The formula only works on the first row of the spreadsheet
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 34: Which of the following is responsible for executing instructions and performing calculations in a computer, often referred to as the 'brain' of the computer?

Random Access Memory (RAM)
Operating System (OS)
Central Processing Unit (CPU) (Correct answer)
Hard Disk Drive (HDD)

Correct answer: Central Processing Unit (CPU)

The Central Processing Unit (CPU) is the primary component of a computer that processes instructions. It runs the operating system and applications, constantly receiving input from the user or active software programs. It processes the data and produces output, which may be stored or displayed on the screen.

Question 35: What is the purpose of a computer's BIOS or UEFI?

To provide antivirus protection before the operating system loads
To initialize hardware components and load the operating system when the computer starts (Correct answer)
To compress files stored on the hard drive to save space
To manage internet connectivity settings for the network adapter

Correct answer: To initialize hardware components and load the operating system when the computer starts

BIOS (Basic Input/Output System) and its modern replacement UEFI run the moment you power on a computer. They perform a POST (Power-On Self-Test) to check hardware, then locate and hand off control to the operating system bootloader.

Question 36: What is a database query used for?

To create a backup of the database
To change the database password
To retrieve specific data that meets certain criteria (Correct answer)
To delete the entire database

Correct answer: To retrieve specific data that meets certain criteria

A database query is a request to retrieve or manipulate data from a database based on specified criteria, typically written in SQL or through a visual query builder.

Question 37: All of the following statements are true except one. Which one is FALSE?

Double-clicking on a Window's Title Bar is another way to maximize and restore the window.
None of the above.
Both the Minimize button and Close button close the window. (Correct answer)
The Maximum button will resize a window to its maximum size.

Correct answer: Both the Minimize button and Close button close the window.

Explanation: <br> The correct answer is "Both of Minimize button and Close button close the window." This statement is false because the minimize button only minimizes the window, while the close button actually closes the window.

Question 38: What does DBMS stand for in the context of database software?

Distributed Base Mapping Service
Data Backup and Management System
Database Management System (Correct answer)
Digital Binary Memory Storage

Correct answer: Database Management System

DBMS stands for Database Management System, which is software that provides tools to create, maintain, and control access to a database.

Question 39: What is social engineering in cybersecurity?

Engineering social networks for better connectivity
Programming chatbots for social media
Manipulating people psychologically to divulge confidential information or perform security-compromising actions (Correct answer)
Building social media websites

Correct answer: Manipulating people psychologically to divulge confidential information or perform security-compromising actions

Social engineering exploits human psychology rather than technical vulnerabilities, using techniques like impersonation, urgency, or trust to trick people into revealing information.

Question 40: What is the advantage of using @mentions in a collaborative messaging or document tool?

They notify a specific person that their attention is needed on something (Correct answer)
They automatically save the document under a new name
They restrict the document so only the mentioned person can view it
They convert the document into a presentation format

Correct answer: They notify a specific person that their attention is needed on something

@mentions tag a specific collaborator and trigger a notification, ensuring the right person sees a message or comment without them having to continuously monitor the tool.

Question 41: What is the purpose of the spelling and grammar checker in a word processor?

It identifies and suggests corrections for spelling errors, grammatical mistakes, and style issues (Correct answer)
It translates the document to another language
It automatically formats the document
It counts the number of words in the document

Correct answer: It identifies and suggests corrections for spelling errors, grammatical mistakes, and style issues

The spelling and grammar checker scans for errors and suggests corrections for misspellings, grammatical mistakes, and sometimes style improvements.

Question 42: 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 method for validating internet connections
A process of backing up spreadsheet data

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 43: What is 'lateral reading' as a fact-checking strategy?

Opening new browser tabs to check what other sources say about a website or claim before reading it deeply (Correct answer)
Comparing the reading level of two competing articles
Scrolling quickly through a webpage to identify key headings
Reading an article from bottom to top to spot errors

Correct answer: Opening new browser tabs to check what other sources say about a website or claim before reading it deeply

Lateral reading means leaving a site and opening multiple tabs to see what independent, credible sources say about it or its claims — a technique used by professional fact-checkers to quickly assess credibility without getting drawn into potentially biased content.

Question 44: What is social engineering in the context of cybersecurity?

Using social media platforms to market products to targeted audiences
Building secure software by involving large teams of developers
Manipulating people psychologically to divulge confidential information or perform actions (Correct answer)
Tracking user behavior across social networks to build advertising profiles

Correct answer: Manipulating people psychologically to divulge confidential information or perform actions

Social engineering exploits human psychology rather than technical vulnerabilities. Attackers use tactics like impersonation, urgency, or fear to trick individuals into revealing passwords, granting access, or transferring funds.

Question 45: Which of the following is an example of a database management system (DBMS)?

Microsoft Access (Correct answer)
Adobe Photoshop
Mozilla Firefox
Microsoft PowerPoint

Correct answer: Microsoft Access

Microsoft Access is a DBMS that provides tools for creating, organizing, querying, and managing databases.

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