Mixed Deck — All IC3 Topics Flashcards

What is mail merge and when would you use it?

Answer: Generating personalized documents by merging a template with a data source

Mail merge combines a document template with a data source (like a spreadsheet) to automatically generate personalized copies for each recipient, commonly used for mass mailings.

What are the security considerations when using online collaboration tools?

Answer: Consider data encryption, access permissions, authentication methods, compliance requirements, and sharing policies

Security considerations include data encryption, multi-factor authentication, appropriate access permissions, compliance with regulations, and secure sharing practices.

What is 'confirmation bias' and how does it affect information consumption?

Answer: The tendency to favor information that confirms existing beliefs while ignoring contradictory evidence

Confirmation bias leads people to seek, interpret, and remember information that supports their existing views while dismissing evidence that challenges them.

Which spreadsheet function calculates the arithmetic mean of a range of cells?

Answer: AVERAGE

The AVERAGE function adds all values in the specified range and divides by the count of numeric entries to return the arithmetic mean.

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?

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.

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

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.

What is the principle of least privilege in cybersecurity?

Answer: Granting users only the minimum access rights necessary to perform their job functions

The principle of least privilege means granting users, applications, and systems only the minimum permissions necessary to perform their required tasks.

What does the 'Slide Master' feature in presentation software primarily control?

Answer: The consistent fonts, colors, and layouts applied across all slides

The Slide Master is a top-level slide that controls the default formatting — fonts, colors, background, and placeholder positions — applied consistently to all slides in the presentation.

What should you do if you suspect your online account has been compromised?

Answer: Immediately change your password, enable 2FA, review account activity, and notify the service provider

If you suspect account compromise, immediately change your password, enable 2FA, review recent account activity, and contact the service provider.

What does conditional formatting do in a spreadsheet?

Answer: It automatically changes the appearance of cells based on the values they contain

Conditional formatting applies visual styling — such as background color, font color, or icons — to cells whose values meet criteria you define, making patterns and outliers easy to spot at a glance. Data validation (not conditional formatting) restricts what can be entered.

What is social engineering in the context of cybersecurity?

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.

What is the primary function of a network router in a home or office?

Answer: To direct internet traffic between devices and the internet service provider

A router directs (routes) data packets between local devices and the internet, enabling multiple devices to share one internet connection.

What is social engineering in cybersecurity?

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.

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

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.

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?

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.

What is the difference between Sleep, Hibernate, and Shut Down modes?

Answer: Sleep saves state to RAM using low power, Hibernate saves to disk using no power, Shut Down closes everything completely

Sleep maintains system state in RAM using minimal power for quick resume. Hibernate saves state to disk and powers off completely. Shut Down closes all programs and powers off.

What is the primary function of RAM (Random Access Memory) in a computer?

Answer: To temporarily hold data and instructions that the CPU is actively using

RAM is volatile memory that temporarily stores data and program instructions the CPU needs right now. Unlike a hard drive, RAM loses its contents when power is removed, which is why unsaved work disappears during a power outage.

What are the benefits of using templates in a word processor?

Answer: Templates provide pre-designed formatting and structure for consistent, professional documents that save time

Templates provide pre-designed layouts, formatting, styles, and sometimes sample content for common document types.

All of the following are true except one. Which one is FALSE?

Answer: An example of outputting is clicking the mouse.

Explanation: The given statement "An example of outputting is clicking the mouse" is false. Outputting refers to the computer displaying information or data, such as the contents of a document on the screen. Clicking the mouse is an input action, as it provides information or commands to the computer

What is the purpose of an index in a database?

Answer: To speed up data retrieval and search operations

An index stores a sorted reference to key field values, allowing the database engine to find matching records much faster than scanning every record.