Key Applications Flashcards
6 cards from real IC3 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Key Applications flashcards as text
In a word processor, what does the 'Track Changes' feature allow you to do?
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.
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.
What is the purpose of a 'master slide' in presentation software?
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.
In a spreadsheet, what does the '$' symbol before a column letter or row number indicate?
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.
What is a database query used for?
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.
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.