IC3 Key Applications 3

Question 1

What is conditional formatting in a spreadsheet?

Accepted Answer

Rules that automatically change cell appearance based on the cell's value

Answer

Formatting that only appears when the document is printed

Answer

A way to password-protect specific cells

Answer

A formula that returns TRUE or FALSE

Question 2

In a word processor, what is the purpose of styles?

Accepted Answer

To apply consistent, predefined formatting to text elements

Answer

To add clip art to documents

Answer

To check spelling and grammar

Answer

To insert page numbers

Question 3

What does the VLOOKUP function do in a spreadsheet?

Accepted Answer

Searches for a value in the first column of a range and returns a value from another column

Answer

Validates that data entries are correct

Answer

Converts vertical data to horizontal layout

Answer

Counts cells that contain text

Question 4

What is the benefit of using slide transitions in a presentation?

Accepted Answer

They provide visual effects between slides for a polished flow

Answer

They reduce the file size

Answer

They add speaker notes

Answer

They automatically time the presentation

Question 5

What is the purpose of cell referencing across worksheets in a spreadsheet?

Accepted Answer

To use data from one worksheet in formulas on another worksheet

Answer

To print multiple worksheets at once

Answer

To merge two worksheets into one

Answer

To apply the same formatting across worksheets

Question 6

In a word processor, what is a section break used for?

Accepted Answer

To divide the document into sections with independent formatting

Answer

To insert a page number

Answer

To create a new paragraph

Answer

To add a table of contents