IC3 Key Applications 2 — Questions and Answers

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

Automatically save documents
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

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.

Track Changes is a collaboration feature in word processors like Microsoft Word and Google Docs that marks up every edit made to a document. Insertions appear with underlining, deletions with strikethrough, and each change is attributed to the user who made it. Reviewers can accept or reject individual changes.

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

SUM
COUNT
AVERAGE (Correct answer)
MAX

Correct 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.

The AVERAGE function in spreadsheet applications like Excel or Google Sheets calculates the arithmetic mean. For example, =AVERAGE(A1:A10) sums all numeric values in cells A1 through A10 and divides by the count of cells that contain numbers. It automatically ignores blank cells and text entries.

Question 3: What is the purpose of a 'master slide' in presentation software?

To create a backup of the presentation
To define consistent formatting and layout across all slides (Correct answer)
To add animations to every slide
To export the presentation as a PDF

Correct answer: To define consistent formatting and layout across all slides

A master slide sets the default fonts, colors, backgrounds, and placeholder positions that apply consistently across all slides in a presentation.

The Slide Master feature allows you to define a consistent design template for your entire presentation. Changes made to the master slide automatically apply to all slides that use that layout. This ensures visual consistency and saves time compared to formatting each slide individually.

Question 4: In a spreadsheet, what does the '$' symbol before a column letter or row number indicate?

The cell contains a currency value
The cell reference is absolute and will not change when copied (Correct answer)
The cell is locked for editing
The cell contains a formula error

Correct answer: The cell reference is absolute and will not change when copied

The dollar sign ($) creates an absolute reference, locking the column, row, or both so the reference doesn't shift when the formula is copied to other cells.

In spreadsheet formulas, the $ symbol creates absolute references. For example, $A$1 locks both column A and row 1, so they remain fixed when the formula is copied. $A1 locks only the column, and A$1 locks only the row (mixed references). Without the $ sign, references are relative and adjust automatically.

Question 5: What is a database query used for?

To delete the entire database
To retrieve specific data that meets certain criteria (Correct answer)
To change the database password
To create a backup of the database

Correct answer: To retrieve specific data that meets certain criteria

A database query is a request to retrieve or manipulate data from a database based on specified criteria, typically written in SQL or through a visual query builder.

A database query is a structured request to extract, filter, sort, or modify data stored in a database. In relational databases, queries are written using SQL with commands like SELECT, WHERE, JOIN, and ORDER BY.

Question 6: What is mail merge and when would you use it?

Combining two email accounts into one
Generating personalized documents by merging a template with a data source (Correct answer)
Forwarding all emails to a single address
Archiving old emails into folders

Correct 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.

Mail merge is a word processing feature that automates the creation of personalized documents. It works by connecting a main document (template) containing placeholders to a data source (spreadsheet, database, or contact list) containing recipient-specific information.

IC3 Key Applications 2

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