IC3 Digital Literacy Certification — Questions and Answers

Question 1: Which of the following is an example of an INPUT device?

Keyboard (Correct answer)
Monitor
Speaker
Printer

Correct answer: Keyboard

A keyboard is an input device because it allows users to send data into the computer.

Question 2: What is the difference between 32-bit and 64-bit operating systems?

32-bit systems are newer than 64-bit systems
The numbers refer to the screen resolution
64-bit systems can address more memory and process larger amounts of data per cycle (Correct answer)
32-bit systems run faster than 64-bit systems

Correct answer: 64-bit systems can address more memory and process larger amounts of data per cycle

A 64-bit operating system can address significantly more RAM (up to 16 exabytes theoretically vs 4GB for 32-bit) and process data in larger chunks.

Question 3: 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.

Question 4: 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 5: What is the purpose of the CONCATENATE or CONCAT function?

It counts the number of characters in a cell
It calculates the total of a range of cells
It splits text in a cell into separate 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 6: How do you use the INDEX and MATCH functions together?

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

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

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

Question 7: What is the purpose of an email signature block?

To limit who can read the email
To prevent spam from being received
To encrypt the email content
To provide consistent contact information and professional identification at the end of messages (Correct answer)

Correct answer: To provide consistent contact information and professional identification at the end of messages

An email signature block automatically appends your name, title, contact information, and optional branding to the end of your emails.

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

Presenter view
Slide Sorter view
Normal view (Correct answer)
Reading 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 9: What is the difference between misinformation and disinformation?

Disinformation is less harmful than misinformation
Misinformation is always in text; disinformation is always in images
Misinformation is false information shared without harmful intent; disinformation is deliberately created to deceive (Correct answer)
They are the same thing

Correct answer: Misinformation is false information shared without harmful intent; disinformation is deliberately created to deceive

Misinformation is inaccurate information shared by people who believe it to be true, while disinformation is intentionally fabricated or misleading content designed to deceive.

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

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

Correct answer: .PDF

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

Question 11: What factors should you consider when choosing between email, instant messaging, and video calling?

Use video calling for everything to appear more professional
Always use email because it is the most professional
Use the newest technology available
Consider the urgency, complexity of the topic, need for documentation, and relationship with the recipient (Correct answer)

Correct answer: Consider the urgency, complexity of the topic, need for documentation, and relationship with the recipient

The right communication channel depends on factors like urgency, message complexity, need for a written record, audience size, topic sensitivity, and the relationship between communicators.

Question 12: In a word processor, what does the 'Track Changes' feature allow you to do?

Record edits so reviewers can see what was modified (Correct answer)
Count the number of words in a document
Change the font throughout the document
Automatically save documents

Correct answer: Record edits so reviewers can see what was modified

Track Changes records all insertions, deletions, and formatting changes made to a document, making it easy for collaborators to review and accept or reject each edit.

Question 13: What does HTTPS indicate about a website?

Communication between your browser and the website is encrypted (Correct answer)
The website loads faster than standard HTTP sites
The website is owned by a government organization
The website has been verified as completely free of malware

Correct answer: Communication between your browser and the website is encrypted

HTTPS (HyperText Transfer Protocol Secure) uses SSL/TLS encryption to protect data transmitted between your browser and the web server, preventing eavesdropping and tampering.

Question 14: A teacher is using a spreadsheet to manage student grades. To find the highest score in a list of grades located in cells C2 through C30, which function would be the most appropriate to use?

=COUNT(C2:C30)
=SUM(C2:C30)
=MAX(C2:C30) (Correct answer)
=AVERAGE(C2:C30)

Correct answer: =MAX(C2:C30)

The MAX function is used to find the maximum or highest value in a given range of cells. AVERAGE calculates the mean, COUNT counts the number of cells with numbers, and SUM adds the values.

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

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

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 16: Why is it important to check the date of publication when evaluating online information?

Publication dates determine search engine rankings
Information may be outdated, and currency affects accuracy in fields where knowledge changes rapidly (Correct answer)
Newer content is always less reliable than older content
Older articles are always more reliable

Correct answer: Information may be outdated, and currency affects accuracy in fields where knowledge changes rapidly

Checking publication dates ensures information is current and relevant, which is critical in fast-changing fields like technology, medicine, and law.

Question 17: What is the primary purpose of a primary key in a database table?

To link two tables together automatically
To uniquely identify each record in the table (Correct answer)
To sort records alphabetically
To restrict who can view the table

Correct answer: To uniquely identify each record in the table

A primary key is a field (or combination of fields) whose value is unique for every record, ensuring each row can be individually identified.

Question 18: Which one of the following applications requires a large computer system such as a mainframe?

Word Processing program
Airline ticket reservation (Correct answer)
Accounting for a small business
Engineering and scientific tasks

Correct answer: Airline ticket reservation

Explanation: <br> Airline ticket reservation systems typically handle a large volume of transactions and require significant processing power, storage, and network capabilities. These systems manage bookings, seat availability, flight schedules, passenger information, and other critical data for multiple flights and airlines. Due to the scale and complexity of these operations, a mainframe or a robust server infrastructure is often used to support the demands of the airline industry. This allows for efficient processing, reliability, and the ability to handle concurrent requests from various users and locations.

Question 19: What is the difference between RAM and ROM?

They are the same type of memory with different names
RAM is volatile read-write memory for active data while ROM is non-volatile read-only memory for firmware (Correct answer)
ROM has more storage capacity than RAM
RAM is slower than ROM

Correct answer: RAM is volatile read-write memory for active data while ROM is non-volatile read-only memory for firmware

RAM is volatile, read-write memory that temporarily holds active data and programs. ROM is non-volatile memory that permanently stores firmware and boot instructions.

Question 20: What is data validation in a spreadsheet?

Rules that restrict the type or range of data that can be entered into specific cells (Correct answer)
A formula for checking password strength
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 21: 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 22: What is the digital divide?

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

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 23: What distinguishes misinformation from disinformation?

Misinformation refers to outdated facts, while disinformation refers to fabricated images
Disinformation only appears on social media, while misinformation appears in print
Misinformation is false information spread without intent to deceive, while disinformation is false information spread deliberately (Correct answer)
Misinformation is always more harmful than disinformation

Correct answer: Misinformation is false information spread without intent to deceive, while disinformation is false information spread deliberately

The key distinction is intent: misinformation is inaccurate content shared by someone who believes it to be true, while disinformation is deliberately crafted and spread to deceive or manipulate audiences.

Question 24: What is social engineering in cybersecurity?

Programming chatbots for social media
Engineering social networks for better connectivity
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 25: What is the main purpose of an operating system's file management system?

To connect to the internet
To control the display settings
To run antivirus software
To organize, store, retrieve, and manage data on storage devices (Correct answer)

Correct answer: To organize, store, retrieve, and manage data on storage devices

The file management system handles how data is organized into files and folders, controls read/write access, and manages storage space on drives.

Question 26: When embedding a video into a presentation, what is a key advantage of embedding over linking?

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

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 27: In a relational database, what connects two related tables?

A macro
A foreign key (Correct answer)
A report
A form

Correct answer: A foreign key

A foreign key is a field in one table that references the primary key of another table, creating the relationship between the two tables.

Question 28: A student is creating a presentation about different types of animals. On a single slide, they want to introduce each animal one by one as they click the mouse. Which feature would be most appropriate for this task?

Animations (Correct answer)
Slide Transitions
SmartArt
Hyperlinks

Correct answer: Animations

Animations are used to add visual effects to individual elements (like text, images, or shapes) within a slide. By applying an 'entrance' animation to each animal's picture or name, the student can make them appear on the slide sequentially with each click.

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

MAC OS
Linux
Windows
DOS (Correct answer)

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 30: Which of the following best describes the relationship between hardware and software?

Hardware is installed on software to increase its capabilities.
Software is the physical, tangible part of the computer, while hardware is the set of instructions.
Software tells the hardware what to do and how to do it. (Correct answer)
Hardware and software are interchangeable terms for computer components.

Correct answer: Software tells the hardware what to do and how to do it.

Hardware refers to the physical components of a computer system that you can touch. Software is a set of instructions or programs that tells the hardware what tasks to perform. Without software, the hardware would not know what to do.

Question 31: What is cloud storage?

A type of SSD installed inside a laptop
Storing data on remote servers accessed via the internet (Correct answer)
Storage built into a computer's motherboard
Temporary RAM used during software installation

Correct answer: Storing data on remote servers accessed via the internet

Cloud storage saves data on remote servers owned by a provider, accessible from any internet-connected device.

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

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

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

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

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

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

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 34: A student team is working on a group presentation. They need a tool that allows them to simultaneously edit the presentation slides, add comments for each other, and track revision history. Which type of digital tool would be most effective for this purpose?

An email client
A standard word processor without cloud features
A cloud-based collaboration suite (e.g., Google Slides, Microsoft 365) (Correct answer)
An instant messaging application

Correct answer: A cloud-based collaboration suite (e.g., Google Slides, Microsoft 365)

Cloud-based collaboration suites like Google Slides or Microsoft 365 are specifically designed for this purpose. They allow multiple users to work on the same file in real-time, leave comments, and track changes, which is ideal for collaborative projects.

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

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)
Images must be placed in headers or footers only
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 36: You are delivering a presentation and want to see your speaker notes and the next slide on your screen, while the audience only sees the current slide. Which presentation mode should you use?

Normal View
Outline View
Reading View
Presenter View (Correct answer)

Correct answer: Presenter View

Presenter View is a special mode available in most presentation software that displays the current slide, speaker notes, and a preview of the next slide on the presenter's screen, while the audience sees only the full-screen current slide on a separate monitor or projector.

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

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

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 38: How do you create and use named ranges in a spreadsheet?

Named ranges automatically sort data
Named ranges delete data in the specified range
Named ranges assign a descriptive name to a cell or range of cells for use in formulas and navigation (Correct answer)
Named ranges are only available in premium versions

Correct answer: Named ranges assign a descriptive name to a cell or range of cells for use in formulas and navigation

Named ranges assign a meaningful name to cells, making formulas more readable and easier to maintain.

Question 39: What is 'lateral reading' as a fact-checking strategy?

Scrolling quickly through a webpage to identify key headings
Reading an article from bottom to top to spot errors
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

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 40: What are the signs of a secure website when entering personal information?

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

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

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

Question 41: When formatting a document, which of the following options primarily controls the amount of white space between the text and the edge of the page?

Page Orientation
Indentation
Line Spacing
Margins (Correct answer)

Correct answer: Margins

Margins define the distance between the text and the top, bottom, left, and right edges of the page. Adjusting the margins is the direct way to control the overall white space bordering the document's content.

Question 42: 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.

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

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

Correct answer: Task Manager

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

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

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

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 45: You are reading a news article about a new city-wide recycling program. The article primarily quotes city officials who praise the program but does not include any comments from residents or waste management experts who might have different perspectives. This is an example of what type of media bias?

Bias by headline
Bias by placement
Bias by photo selection
Bias by omission (Correct answer)

Correct answer: Bias by omission

Bias by omission occurs when a media outlet leaves out one side or important aspects of a story, creating an unbalanced or incomplete picture. By only including the positive viewpoints of city officials and excluding other relevant perspectives, the article fails to provide a comprehensive view of the new program.

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