IC3 Key Applications 2

Question 1

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

Accepted Answer

Record edits so reviewers can see what was modified

Answer

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.

Question 2

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

Accepted Answer

AVERAGE

Answer

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

Question 3

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

Accepted Answer

To define consistent formatting and layout across all slides

Answer

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

Question 4

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

Accepted Answer

The cell reference is absolute and will not change when copied

Answer

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.

Question 5

What is a database query used for?

Accepted Answer

To retrieve specific data that meets certain criteria

Answer

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.

IC3 - Digital Literacy Certification Practice Test

IC3 - Digital Literacy Certification Practice Test

IC3 Key Applications 2