OSC Computer and Technology Skills 3

Question 1

Which Excel function looks up a value in the first column of a table and returns a value in the same row?

Accepted Answer

VLOOKUP

Answer

VLOOKUP (Vertical Lookup) searches a table's first column for a value and returns a corresponding cell in the specified column.

Question 2

What is the purpose of a network firewall in an office setting?

Accepted Answer

Monitor and control incoming and outgoing network traffic

Answer

A firewall filters network traffic according to security rules, blocking unauthorized access while allowing legitimate communication.

Question 3

In office software, 'version control' refers to:

Accepted Answer

Tracking and managing changes to a document over time

Answer

Version control maintains a history of document changes, allowing users to review, compare, or revert to earlier versions.

Question 4

What is the function of the Freeze Panes feature in Excel?

Accepted Answer

Keep specific rows or columns visible while scrolling

Answer

Freeze Panes locks header rows or columns in place so they remain visible as you scroll through large spreadsheets.

Question 5

Which of the following file extensions indicates a compressed archive?

Accepted Answer

.zip

Answer

A .zip file is a compressed archive that bundles multiple files into one smaller file for easier sharing or storage.

OSC - Office Skills Certification Practice Test