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. What is the safest practice when creating passwords for multiple online accounts? → Use a unique, complex password for each account, ideally managed with a password manager
5. Which operating system management function is primarily responsible for organizing, storing, and retrieving files and folders on a storage device? → File System Management
6. Which protocol is commonly used for secure email transmission? → TLS/SSL
7. What does a device driver do? → Acts as a translator between the operating system and a hardware device
8. Which spreadsheet function calculates the arithmetic mean of a range of cells? → AVERAGE
9. What is the primary advantage of using BCC (Blind Carbon Copy) in email? → It hides recipient addresses from other recipients for privacy
10. A student copies a paragraph from a website into their school essay without citing the source. This is an example of: → Plagiarism
11. What does the IF function do in a spreadsheet? → It performs a logical test and returns one value if true and another if false
12. Which of the following is a characteristic that distinguishes VoIP from traditional telephone communication? → VoIP converts voice into digital packets transmitted over the internet
13. Which of the following is NOT a common database object in Microsoft Access? → Slide
14. In a word processor, what is the purpose of styles? → To apply consistent, predefined formatting to text elements
15. What is a VPN and when should you use one? → A Virtual Private Network that encrypts your internet connection and masks your IP address
16. What is data validation in a spreadsheet? → Rules that restrict the type or range of data that can be entered into specific cells
17. 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
18. What is data validation in a database context? → Rules that control what data can be entered into a field
19. 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
20. What is cyberbullying and what makes it different from traditional bullying? → It uses digital devices and platforms, can be anonymous, and persists 24/7
21. 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
22. What is mail merge and when would you use it? → Generating personalized documents by merging a template with a data source
23. Which of the following printers is best suited for printing large drawings such as architectural blueprints? → Plotter
24. Which of the following is an example of poor netiquette in a professional online setting? → TYPING A MESSAGE IN ALL CAPITAL LETTERS.
25. Which of the following best describes an operating system? → System software that manages hardware and provides services for application programs
26. 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
27. When sorting database records in ascending order on a 'Last Name' field, which entry appears first? → Anderson
28. Which data type should be used to store a person's age in a database field? → Number
29. 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
30. In a word processor, what does the 'Track Changes' feature allow you to do? → Record edits so reviewers can see what was modified