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

Automatically save documents

Answer

Count the number of words in a document

Answer

Change the font throughout the document

Question 2

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

Accepted Answer

AVERAGE

Answer

SUM

Answer

COUNT

Answer

MAX

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

To create a backup of the presentation

Answer

To add animations to every slide

Answer

To export the presentation as a PDF

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 cell contains a currency value

Answer

The cell is locked for editing

Answer

The cell contains a formula error

Question 5

What is a database query used for?

Accepted Answer

To retrieve specific data that meets certain criteria

Answer

To delete the entire database

Answer

To change the database password

Answer

To create a backup of the database

Question 6

What is mail merge and when would you use it?

Accepted Answer

Generating personalized documents by merging a template with a data source

Answer

Combining two email accounts into one

Answer

Forwarding all emails to a single address

Answer

Archiving old emails into folders