IC3 Cheat Sheet 2026

The 30 highest-yield IC3 facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. In Microsoft Word, what is the function of the 'Save As' command? → It saves the document with a new name, location, or file format
2. In a spreadsheet, what does the '$' symbol before a column letter or row number indicate? → The cell reference is absolute and will not change when copied
3. Which of the following best describes the relationship between hardware and software? → Software tells the hardware what to do and how to do it.
4. Which operating system management function is primarily responsible for organizing, storing, and retrieving files and folders on a storage device? → File System Management
5. Which protocol is commonly used for secure email transmission? → TLS/SSL
6. Which spreadsheet function calculates the arithmetic mean of a range of cells? → AVERAGE
7. What is the primary advantage of using BCC (Blind Carbon Copy) in email? → It hides recipient addresses from other recipients for privacy
8. What does the IF function do in a spreadsheet? → It performs a logical test and returns one value if true and another if false
9. Which of the following is NOT a common database object in Microsoft Access? → Slide
10. In a word processor, what is the purpose of styles? → To apply consistent, predefined formatting to text elements
11. What is a VPN and when should you use one? → A Virtual Private Network that encrypts your internet connection and masks your IP address
12. What is data validation in a spreadsheet? → Rules that restrict the type or range of data that can be entered into specific cells
13. 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? → Margins
14. What is data validation in a database context? → Rules that control what data can be entered into a field
15. What are file system permissions and how do they work? → They control which users and groups can read, write, or execute specific files and folders
16. What is cyberbullying and what makes it different from traditional bullying? → It uses digital devices and platforms, can be anonymous, and persists 24/7
17. What is a kanban board and how is it used in project management? → A visual workflow management tool that uses columns and cards to track task progress
18. What is mail merge and when would you use it? → Generating personalized documents by merging a template with a data source
19. Which of the following printers is best suited for printing large drawings such as architectural blueprints? → Plotter
20. Which of the following is an example of poor netiquette in a professional online setting? → TYPING A MESSAGE IN ALL CAPITAL LETTERS.
21. Which of the following best describes an operating system? → System software that manages hardware and provides services for application programs
22. A user is trying to set up a new printer, but the computer does not recognize it. Which of the following components is MOST likely missing or corrupted? → The device driver
23. When sorting database records in ascending order on a 'Last Name' field, which entry appears first? → Anderson
24. Which data type should be used to store a person's age in a database field? → Number
25. In a word processor, what does the 'Track Changes' feature allow you to do? → Record edits so reviewers can see what was modified
26. 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.
27. What is the purpose of version history in collaborative tools? → To track all changes over time and allow restoration of previous document states
28. What is the digital divide? → The gap between those who have access to digital technology and those who do not
29. What does 'email threading' or 'conversation view' organize? → Related emails in a chain grouped together by subject
30. What best describes a discussion forum as a communication tool? → An organized online space where users post and reply to topic-based threads asynchronously