IC3 Digital Literacy Certification — Questions and Answers

Question 1: What is a macro in spreadsheet software?

A keyboard shortcut for copy and paste
A type of chart
A large-format print setting
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 2: A desktop computer runs loud fans and shuts down unexpectedly during heavy use. What is the most likely cause?

An expired software license
A slow internet connection
A corrupted user profile
Overheating due to poor cooling or dust buildup (Correct answer)

Correct answer: Overheating due to poor cooling or dust buildup

Sudden shutdowns under load with loud fans are classic signs of overheating that triggers thermal protection.

Question 3: A user turns off GPS on their phone, but a weather app still shows their neighborhood fairly accurately. Location permission is still granted to the app. What is the best explanation?

The phone can estimate location from nearby Wi-Fi networks and cell towers even without GPS (Correct answer)
The weather app caches a permanent location from the day it was installed and never updates it
GPS cannot actually be disabled. The setting only hides the GPS icon
The app is reading the user's location from their saved contacts

Correct answer: The phone can estimate location from nearby Wi-Fi networks and cell towers even without GPS

Mobile location services combine several sources. Besides GPS satellites, the device can estimate its position from nearby Wi-Fi access points and from cell tower triangulation, often to within a few blocks. To stop an app from getting a location at all, the user has to revoke the app's location permission or turn off location services completely, not just GPS.

Question 4: Which type of chart is best suited for showing the proportion of individual parts to a whole, such as the percentage breakdown of a monthly budget?

Scatter Plot
Line Chart
Bar Chart
Pie Chart (Correct answer)

Correct answer: Pie Chart

A Pie Chart is the ideal visualization for representing data as percentages or proportions of a whole. Each 'slice' of the pie represents a category's contribution to the total.

Question 5: How do you ensure a presentation is accessible to all audience members?

Use the smallest font possible to fit more content
Accessibility features are not available in presentation software
Add alt text to images, use sufficient color contrast, maintain logical reading order, and include captions for media (Correct answer)
Only print handouts for accessibility

Correct answer: Add alt text to images, use sufficient color contrast, maintain logical reading order, and include captions for media

Accessible presentations include alt text for images, sufficient color contrast, logical reading order, large fonts, and captioned multimedia.

Question 6: You inserted a 4-column table and need to total the numbers in the last column inside Word. Which feature helps?

Convert Text to Table
Sort
Split Cells
Insert Formula (=SUM(ABOVE)) (Correct answer)

Correct answer: Insert Formula (=SUM(ABOVE))

Word's table Formula command can calculate totals with functions like =SUM(ABOVE).

Question 7: When you 'indent' a paragraph in a word processor, what are you doing?

Increasing the font size of the first line
Adding extra space above the paragraph
Moving the paragraph text inward from the left or right margin (Correct answer)
Centering the paragraph on the page

Correct answer: Moving the paragraph text inward from the left or right margin

Indenting shifts the paragraph's text away from the page margin, which is commonly used to mark the start of a new paragraph, format block quotes, or create nested lists.

Question 8: Why is it important to keep your operating system and software updated?

Updates remove features that slow down your computer
Updates patch security vulnerabilities that attackers could otherwise exploit (Correct answer)
Updates are required by law in most countries
Updates improve the visual appearance of the software interface

Correct answer: Updates patch security vulnerabilities that attackers could otherwise exploit

Software updates frequently include security patches that fix known vulnerabilities. Unpatched systems are common targets for cyberattacks because the weaknesses are publicly known and easily exploited.

Question 9: What is the purpose of using 'styles' (such as Heading 1, Heading 2, Normal) in a word processor?

To insert decorative borders around text
To change the document's file format
To apply consistent formatting across the document and enable features like automatic navigation and table of contents generation (Correct answer)
To lock sections of the document from editing

Correct answer: To apply consistent formatting across the document and enable features like automatic navigation and table of contents generation

Built-in styles apply uniform formatting with a single click and also allow the word processor to identify document structure, which is used to auto-generate tables of contents and enable the navigation pane.

Question 10: What is a firewall and how does it protect a network?

A tool for speeding up internet connections
A backup power supply for computers
A physical wall that prevents fire damage to servers
A security system that monitors and filters network traffic based on predefined rules (Correct answer)

Correct answer: A security system that monitors and filters network traffic based on predefined rules

A firewall monitors incoming and outgoing traffic and blocks or allows data packets based on security rules, acting as a barrier between trusted and untrusted networks.

Question 11: Why is it important to keep software and operating systems updated?

Updates patch security vulnerabilities, fix bugs, and protect against newly discovered threats (Correct answer)
Updates are only needed for gaming computers
Updates always slow down devices
Updates only change the visual appearance

Correct answer: Updates patch security vulnerabilities, fix bugs, and protect against newly discovered threats

Software updates patch known security vulnerabilities that attackers actively exploit, fix bugs, and improve functionality.

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

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

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 13: You edit a document stored in OneDrive on your laptop, then open it on your phone and see the changes. What feature made this possible?

Cloud synchronization (Correct answer)
File compression
Bluetooth file transfer
Local caching only

Correct answer: Cloud synchronization

Cloud sync keeps the same file updated across all devices signed in to the account.

Question 14: Which wireless security protocol provides the strongest protection for a home Wi-Fi network?

WPA3 (Correct answer)
WEP
WPA
Open (no security)

Correct answer: WPA3

WPA3 is the latest Wi-Fi security standard with stronger encryption than WEP, WPA, and WPA2.

Question 15: Which of the following actions contributes to a person's passive digital footprint?

A website installing a cookie on your browser to track your visit. (Correct answer)
Sending a private email to a friend.
Posting a comment on a social media platform.
Publishing a blog post under your own name.

Correct answer: A website installing a cookie on your browser to track your visit.

A digital footprint is the trail of data you leave online. An active footprint is created when a user deliberately shares information (e.g., posting on social media). A passive footprint is created without the user's active input, such as when websites collect information about visits, IP addresses, and browsing history through cookies.

Question 16: A user wants to calculate the total sales from cells B2 through B25 in a spreadsheet. Which formula should they enter into the cell where they want the total to appear?

=SUM(B2:B25) (Correct answer)
=ADD(B2:B25)
=TOTAL(B2-B25)
SUM(B2..B25)

Correct answer: =SUM(B2:B25)

The SUM function is the standard spreadsheet function used to add all the numbers in a range of cells. The range is specified with a colon (:) between the starting and ending cells, and all formulas must begin with an equals sign (=).

Question 17: In a team project management tool, what is the function of a 'due date' attached to a task?

It sends the task to an archive folder
It sets a deadline to help the team prioritize and track timely completion (Correct answer)
It automatically completes the task on that date
It locks the task so no one can edit it after that date

Correct answer: It sets a deadline to help the team prioritize and track timely completion

Due dates give tasks a target completion time, helping team members prioritize their work and allowing project managers to monitor whether the project is on schedule.

Question 18: 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?

WordArt
Drawing Tools
Template (Correct answer)
Chart Tool

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 19: A company wants every slide in a PowerPoint presentation, including slides added later from any layout, to use the same corporate font in the title placeholders. What is the most efficient way to do this?

Use Format Painter to copy the title formatting from the first slide to every other slide
Select all slides in Slide Sorter view and change the title font
Change the title font on the 'Title and Content' layout in Slide Master view
Change the title font on the top (parent) Slide Master in Slide Master view (Correct answer)

Correct answer: Change the title font on the top (parent) Slide Master in Slide Master view

The top-level Slide Master controls formatting for every layout under it. A change there flows down to all existing slides and to any new slides based on those layouts. Changing a single layout affects only slides that use that layout. Formatting slides by hand or with Format Painter changes only the slides that exist now, not slides added later.

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

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

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 21: How do you effectively use animations in a presentation?

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

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 22: A user edits a document stored in a shared cloud folder on their office computer. The next day, working from home, they open the same document on their laptop but find that their recent changes are missing. Which of the following is the MOST likely cause of this issue?

The user's account password expired overnight.
The office computer failed to synchronize the changes with the cloud server. (Correct answer)
The laptop does not have the correct application installed.
The cloud service permanently deleted the changes.

Correct answer: The office computer failed to synchronize the changes with the cloud server.

Cloud storage relies on a synchronization process to upload changes from a local device to the cloud server and then download them to other connected devices. A failure in this process, often due to a poor internet connection or a paused sync client on the original computer, is the most common reason for changes not appearing on another device.

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

Animation
Theme
Transition (Correct answer)
Template

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 24: An employee is setting up a new account for a critical work system. Which of the following passwords is the MOST secure?

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

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 25: A document has three sections. You type a new header in Section 3, and the same text immediately appears in Section 2's header, which you didn't want. What should you have done first?

Turned on 'Different First Page' in Section 3
Inserted a Continuous section break at the top of Section 3
Turned off 'Link to Previous' in Section 2's header
Turned off 'Link to Previous' in Section 3's header (Correct answer)

Correct answer: Turned off 'Link to Previous' in Section 3's header

Each section's header is linked to the one before it by default. To give Section 3 its own header, open Section 3's header and turn off 'Link to Previous'. Unlinking Section 2 would only separate it from Section 1. 'Different First Page' only affects the first page of a section. Adding another break doesn't remove the link.

Question 26: 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?

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

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 27: Which of the following best describes a phishing attack?

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

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

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

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 29: Which is a key advantage of saving documents in the cloud rather than only on a local hard drive?

They never need a password
They use no storage space at all
They can be accessed and shared from multiple devices (Correct answer)
They work with no internet access ever

Correct answer: They can be accessed and shared from multiple devices

Cloud storage lets you reach files from different devices and share them with others, and it often provides backup and version history.

Question 30: Cell B2 of a spreadsheet contains the formula =$A2*B$1. You copy B2 and paste it into cell D5. Which formula will D5 contain?

=$A5*D$1 (Correct answer)
=$C5*D$1
=$A5*D$4
=$A2*D$1

Correct answer: =$A5*D$1

Both references are mixed. In $A2 the column is locked and the row is relative, so moving down 3 rows changes it to $A5. In B$1 the row is locked and the column is relative, so moving right 2 columns changes it to D$1. The result is =$A5*D$1.

Question 31: What does the 'Track Changes' feature do in a word processor?

Records all edits made to a document so they can be reviewed and accepted or rejected (Correct answer)
Saves a backup copy of the document automatically
Highlights text in different colors for emphasis
Converts the document to a read-only format

Correct answer: Records all edits made to a document so they can be reviewed and accepted or rejected

Track Changes logs every insertion, deletion, and formatting change so collaborators can see exactly what was modified and decide whether to keep each edit.

Question 32: Which of the following is an example of poor netiquette in a professional online setting?

TYPING A MESSAGE IN ALL CAPITAL LETTERS. (Correct answer)
Proofreading a message for spelling and grammar errors before sending.
Including a professional signature with your contact information.
Using a clear and descriptive subject line in an email.

Correct answer: TYPING A MESSAGE IN ALL CAPITAL LETTERS.

Using all capital letters in online communication is widely interpreted as shouting or being aggressive and is considered poor netiquette. The other options are all examples of good professional netiquette that facilitate clear and respectful communication.

Question 33: A user complains that their computer is running very slowly, especially when they have multiple programs open. They have an older computer with limited RAM. Which of the following hardware upgrades would MOST likely resolve this performance issue?

Replacing the computer's mouse and keyboard.
Installing a larger hard disk drive.
Adding more Random Access Memory (RAM). (Correct answer)
Upgrading the monitor to a higher resolution.

Correct answer: Adding more Random Access Memory (RAM).

RAM (Random Access Memory) is used by the computer to hold data for currently running programs. When there isn't enough RAM to hold all the open programs, the operating system has to swap data to the much slower hard drive, which significantly degrades performance. Increasing the amount of RAM allows the computer to handle more programs simultaneously without this slowdown.

Question 34: What is digital literacy in the context of responsible technology use?

Owning the latest electronic devices
Knowing how to type quickly
Having accounts on all social media platforms
The ability to use, evaluate, and create information using digital technology responsibly (Correct answer)

Correct answer: The ability to use, evaluate, and create information using digital technology responsibly

Digital literacy encompasses not just technical skills but the ability to critically evaluate digital content, understand ethical implications, and use technology responsibly.

Question 35: What is real-time co-authoring in cloud-based documents?

Sending document drafts via email
Saving multiple versions of a document locally
Printing a document for group review
Multiple users editing the same document simultaneously with changes visible instantly (Correct answer)

Correct answer: Multiple users editing the same document simultaneously with changes visible instantly

Real-time co-authoring allows multiple users to work on the same cloud-based document simultaneously, with each person's changes appearing instantly.

Question 36: Which spreadsheet function calculates the total of all values in a selected range of cells?

AVERAGE
COUNT
SUM (Correct answer)
MAX

Correct answer: SUM

The SUM function adds together all numeric values within a specified range, making it the correct choice for calculating a total. COUNT counts the number of cells, AVERAGE computes the mean, and MAX returns the highest value.

Question 37: Which of the following is an example of application software?

macOS
A device driver
A web browser (Correct answer)
Microsoft Windows

Correct answer: A web browser

A web browser is a type of application software designed to perform a specific task for the user, in this case, accessing and viewing websites. Microsoft Windows and macOS are operating systems (system software), and a device driver is a specialized software that allows the operating system to communicate with a hardware device.

Question 38: What is the digital divide?

The difference between digital and analog signals
The gap between those who have access to digital technology and those who do not (Correct answer)
A type of computer virus
A method of splitting data across multiple servers

Correct answer: The gap between those who have access to digital technology and those who do not

The digital divide refers to the inequality in access to computers, internet connectivity, and digital literacy skills between different socioeconomic, geographic, or demographic groups.

Question 39: On a Windows computer, what does a file with the .exe extension usually represent?

A compressed archive
A spreadsheet
An image file
An executable program (Correct answer)

Correct answer: An executable program

The .exe extension marks an executable file that launches a program when opened.

Question 40: What does 'netiquette' refer to in online communication?

A type of antivirus software
A programming language for websites
The set of social conventions and rules for polite behavior on the internet (Correct answer)
A method of encrypting email messages

Correct answer: The set of social conventions and rules for polite behavior on the internet

Netiquette (internet etiquette) encompasses the accepted norms and guidelines for respectful, appropriate communication and behavior in online environments.

Question 41: Saving files to Google Drive or OneDrive so they can be accessed from any device is an example of what?

Intranet hosting
Local backup
Cloud storage (Correct answer)
Peer-to-peer sharing

Correct answer: Cloud storage

Cloud storage keeps files on remote internet servers accessible from any connected device.

Question 42: A user installs 8 GB of RAM in a laptop, but System Properties reports only about 3.2 GB usable. The RAM modules test fine and the BIOS shows all 8 GB. What is the most likely explanation?

The RAM modules have mismatched speeds, so the system disables one channel
Virtual memory is turned off, so Windows can't map the remaining physical RAM
The integrated graphics chip has reserved about 4.8 GB as shared video memory
The installed operating system is 32-bit, which can only address about 4 GB in total, and part of that is reserved for hardware (Correct answer)

Correct answer: The installed operating system is 32-bit, which can only address about 4 GB in total, and part of that is reserved for hardware

A 32-bit operating system can address at most 2^32 bytes, which is 4 GB. Part of that address space is reserved for devices such as the graphics card and PCI hardware, so typically only 3–3.5 GB is usable. Installing a 64-bit operating system would make all 8 GB available. Integrated graphics might reserve a few hundred MB, not almost 5 GB. Mismatched RAM speeds usually cause the modules to run at the slower speed, not to lose capacity.

Question 43: What does 'kerning' refer to in the context of presentation text formatting?

The spacing adjustment between individual pairs of characters (Correct answer)
The vertical spacing between lines of text
The overall margin around a text box
The shadow effect applied to letters

Correct answer: The spacing adjustment between individual pairs of characters

Kerning specifically refers to adjusting the horizontal spacing between individual character pairs to improve visual balance and readability, distinct from general letter-spacing or line spacing.

Question 44: What is a digital signature in the context of electronic communication?

A scanned image of a handwritten signature
A cryptographic technique that verifies the sender's identity and message integrity (Correct answer)
A signature line at the end of an email
A username used to log into email

Correct answer: A cryptographic technique that verifies the sender's identity and message integrity

A digital signature uses public-key cryptography to mathematically verify that a message was sent by the claimed sender and has not been altered in transit.

Question 45: A user reports that their computer is running very slowly and frequently crashes. They have not installed any new software recently. Which of the following is the MOST likely cause and first step in troubleshooting?

The operating system is outdated and needs to be reinstalled immediately.
A critical hardware component like the CPU has failed.
The computer has a virus, and a full system scan should be performed.
The hard drive is full, and the user should run a disk cleanup utility. (Correct answer)

Correct answer: The hard drive is full, and the user should run a disk cleanup utility.

Sluggish performance and unexpected crashes are common symptoms of a hard drive that is nearing capacity. The operating system needs sufficient free space to function correctly, for virtual memory (swap files), and for temporary files. Running a disk cleanup utility is a non-destructive first step to reclaim space and often resolves these issues.

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

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

certiport.pearsonvue.com — Passing score, exam format · verified Nov 2026
store.certiport.com — Test delivery · verified Nov 2026