IC3 Digital Literacy Certification — Questions and Answers

Question 1: Which of the following is the primary reason for citing sources in a research paper or project?

To give credit to the original authors and allow readers to locate the source material. (Correct answer)
To meet the minimum word count requirement for the assignment.
To make the paper look more professional by including a bibliography.
To demonstrate that you agree with everything the source author has written.

Correct answer: To give credit to the original authors and allow readers to locate the source material.

The primary purposes of citation are to avoid plagiarism by giving credit to the original creators of ideas and information, and to provide a path for readers to find the original sources themselves to verify the information or learn more. While it adds to the professionalism of a paper, its core function is academic honesty and traceability.

Question 2: Which of the following printers is best suited for printing large drawings such as architectural blueprints?

Dot-Matrix
Inkjet
Laser
Plotter (Correct answer)

Correct answer: Plotter

Explanation: <br> A plotter is the best printer for printing large drawings such as architectural blueprints because it uses pens to draw continuous lines, allowing for precise and accurate printing of detailed designs. Unlike other printers, a plotter can handle large paper sizes and produce high-quality prints with sharp lines and fine details, making it the ideal choice for printing large-scale technical drawings.

Question 3: What is cyberbullying and what makes it different from traditional bullying?

It is less harmful than in-person bullying
It uses digital devices and platforms, can be anonymous, and persists 24/7 (Correct answer)
It only occurs during school hours
It only affects adults

Correct answer: It uses digital devices and platforms, can be anonymous, and persists 24/7

Cyberbullying uses digital technology to harass, threaten, or humiliate others. Unlike traditional bullying, it can occur anonymously, reaches a wider audience, persists around the clock, and digital content can be permanent.

Question 4: What happens when you install software on a computer?

Program files are copied to the computer's storage and configured to run (Correct answer)
The CPU is upgraded to support the new program
The software is stored in RAM permanently
The operating system is replaced with the new software

Correct answer: Program files are copied to the computer's storage and configured to run

Installing software copies program files to the hard drive and configures the OS to recognize and run the application.

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

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)
The record is automatically archived to another table

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 6: Which protocol is commonly used for secure email transmission?

FTP
TLS/SSL (Correct answer)
HTTP
DNS

Correct answer: TLS/SSL

TLS (Transport Layer Security) and its predecessor SSL encrypt the connection between email servers, protecting message content from interception during transmission.

Question 7: What is the role of the CPU (Central Processing Unit) in a computer?

To regulate power delivery to all internal components
To display images and video on the monitor
To store the operating system permanently
To execute instructions and perform calculations for all running programs (Correct answer)

Correct answer: To execute instructions and perform calculations for all running programs

The CPU is the brain of the computer — it fetches, decodes, and executes instructions from software. Every calculation, logic operation, and data movement passes through the CPU.

Question 8: What does CPU stand for in computer terminology?

Central Processing Unit (Correct answer)
Computer Personal Unit
Core Processing Unit
Central Program Utility

Correct answer: Central Processing Unit

CPU stands for Central Processing Unit, the primary component that executes instructions in a computer.

Question 9: 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 add animations to all objects simultaneously
To delete multiple objects at once

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 10: When sorting database records in ascending order on a 'Last Name' field, which entry appears first?

Anderson (Correct answer)
Thompson
Williams
Martinez

Correct answer: Anderson

Ascending alphabetical order starts from A; 'Anderson' begins with 'A', placing it before names starting with later letters.

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

Audio jack
Ethernet
HDMI (Correct answer)
USB-A

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 12: What is the difference between a presentation template and a theme?

Themes only apply to text while templates apply to images
Templates are free while themes are paid
A template includes pre-built slide layouts and placeholder content while a theme defines colors, fonts, and backgrounds (Correct answer)
There is no difference between them

Correct answer: A template includes pre-built slide layouts and placeholder content while a theme defines colors, fonts, and backgrounds

A theme defines visual design elements (colors, fonts, backgrounds) while a template includes a theme plus pre-built layouts and sample content.

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

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

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.

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

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

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 15: 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 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)
SUM(B2..B25)
=TOTAL(B2-B25)
=ADD(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: 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)
Text Box
Footnote
Endnote

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: When embedding a video into a presentation, what is a key advantage of embedding over linking?

The video quality automatically improves
The presentation loads faster
The video plays even if the original file is moved or deleted (Correct answer)
The file size of the presentation decreases

Correct answer: The video plays even if the original file is moved or deleted

Embedding stores the video directly inside the presentation file, so it plays correctly regardless of whether the original video file is available, unlike a link which breaks if the source file moves.

Question 19: Which of the following is an example of synchronous communication?

Posting a comment on an online forum
Sending a text message and waiting for a reply
Leaving a voicemail for a colleague
Participating in a live video meeting (Correct answer)

Correct answer: Participating in a live video meeting

Synchronous communication happens in real-time, requiring all participants to be engaged simultaneously. A live video meeting fits this description, whereas emails, text messages, and forum posts are asynchronous, as they don't require an immediate response.

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

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)
Images cannot be inserted into word processors
Images can only be pasted from the clipboard

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 21: Which spreadsheet function calculates the total of all values in a selected range of cells?

COUNT
SUM (Correct answer)
AVERAGE
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 22: What is character and paragraph formatting and how do they differ?

Character formatting is for numbers; paragraph formatting is for letters
Character formatting affects the page layout; paragraph formatting affects fonts
Character formatting affects individual text properties like font and size while paragraph formatting controls alignment, spacing, and indentation (Correct answer)
They are identical features with different names

Correct answer: Character formatting affects individual text properties like font and size while paragraph formatting controls alignment, spacing, and indentation

Character formatting controls individual characters (font, size, bold, color), while paragraph formatting controls how paragraphs behave (alignment, spacing, indentation).

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

Manipulating people psychologically to divulge confidential information or perform actions (Correct answer)
Using social media platforms to market products to targeted audiences
Building secure software by involving large teams of developers
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 24: All of the following statements are true except one. Which one is FALSE?

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

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 25: What does 'kerning' refer to in the context of presentation text formatting?

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

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 26: A team is working on a presentation for an upcoming conference. To ensure a consistent and professional look across all slides, with the company logo and specific fonts applied automatically to each new slide, which feature should they utilize?

Animation Painter
Presenter View
Slide Master (Correct answer)
Slide Sorter

Correct answer: Slide Master

The Slide Master feature in presentation software allows you to define a consistent layout, including background elements, fonts, colors, and logos, that will be applied to all slides using that master. This ensures uniformity and saves time by not having to format each slide individually.

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

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

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 28: How do you create a table of contents in a word processor?

Manually type each chapter title with its page number
Copy and paste headings into a separate document
Tables of contents can only be created in spreadsheet software
Apply heading styles to section titles and use the automatic table of contents generator (Correct answer)

Correct answer: Apply heading styles to section titles and use the automatic table of contents generator

Automatic table of contents generation uses heading styles applied to section titles to create a clickable, updating table of contents.

Question 29: Which of the following BEST describes a person's "digital footprint"?

The list of websites they have bookmarked in their web browser.
The collective trail of data, posts, and interactions they leave online. (Correct answer)
The security software they have installed to protect their online identity.
The physical size of all the files stored on their personal computer.

Correct answer: The collective trail of data, posts, and interactions they leave online.

A digital footprint is the record of a person's online activity, including social media posts, search history, comments, and photos. It is not about local file size, the security software used, or private browser bookmarks.

Question 30: Which operating system does this picture belong to?

Windows
DOS (Correct answer)
MAC OS
Linux

Correct answer: DOS

Explanation: <br> The correct answer is DOS because the picture likely shows the command prompt interface of the DOS operating system. DOS, which stands for Disk Operating System, was a popular operating system in the early days of personal computers. It featured a command-line interface where users could enter commands to perform tasks. The picture may show the characteristic black screen with white or green text that was common in DOS.

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

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

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 32: What is 'astroturfing' in the context of online media?

Using bots to artificially inflate a video's view count
Creating the false impression of widespread grassroots public support for a position, often orchestrated by a hidden organization (Correct answer)
Hiding advertisements inside editorial content
Copying content from one website and republishing it without attribution

Correct answer: Creating the false impression of widespread grassroots public support for a position, often orchestrated by a hidden organization

Astroturfing creates the illusion of organic, grassroots support when the activity is actually coordinated and funded by a concealed group — mimicking real public opinion to manipulate perception.

Question 33: What is cloud computing?

Delivering computing services over the internet on demand (Correct answer)
A type of local area network
A method of cleaning computer components
A type of weather prediction software

Correct answer: Delivering computing services over the internet on demand

Cloud computing delivers computing resources such as storage, processing power, and applications over the internet, allowing users to access them on demand without owning physical infrastructure.

Question 34: What does 'email threading' or 'conversation view' organize?

Emails by the color of their labels
Emails by sender's location
Related emails in a chain grouped together by subject (Correct answer)
Emails by file attachment size

Correct answer: Related emails in a chain grouped together by subject

Email threading groups all related messages in a conversation together based on subject line and message headers, making it easier to follow the progression of a discussion.

Question 35: Which SQL keyword is used to retrieve data from a database table?

UPDATE
SELECT (Correct answer)
DELETE
INSERT

Correct answer: SELECT

The SELECT statement is the fundamental SQL command for querying and retrieving data from one or more database tables.

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

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

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 37: 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 automatically completes the task on that date
It sets a deadline to help the team prioritize and track timely completion (Correct answer)
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 38: You are at a coffee shop using their public Wi-Fi network. Which of the following activities should you AVOID doing?

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

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 39: 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 40: Why is it important to check the publication date when evaluating an online article?

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

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

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

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 42: What is the difference between primary and secondary sources?

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

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 43: A sales manager has a spreadsheet containing data for all sales transactions for the year. They want to view only the sales made by a specific employee, 'Jane Doe'. Which feature should they use to temporarily hide all rows except those for Jane Doe?

Filtering (Correct answer)
Find and Replace
Sorting
Charting

Correct answer: Filtering

Filtering allows a user to display only the rows that meet certain criteria while temporarily hiding all other rows. Sorting would rearrange the data but would still show all employees. Find and Replace is for changing data, and Charting is for visualizing it.

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

The formula in the cell has an error.
The cell is locked and cannot be edited.
The cell contains currency data.
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 45: What is a firewall and how does it protect a network?

A backup power supply for computers
A tool for speeding up internet connections
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.

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