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

SUMIF

Answer

COUNTIF

Answer

AVERAGE

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

Speed up internet downloads

Answer

Store backup files

Answer

Format network printers

Question 3

In office software, 'version control' refers to:

Accepted Answer

Tracking and managing changes to a document over time

Answer

Updating software to the latest version

Answer

Controlling who can print documents

Answer

Setting page version numbers

Question 4

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

Accepted Answer

Keep specific rows or columns visible while scrolling

Answer

Lock cells to prevent editing

Answer

Merge selected cells together

Answer

Apply a filter to the data

Question 5

Which of the following file extensions indicates a compressed archive?

Accepted Answer

.zip

Answer

.xlsx

Answer

.docx

Answer

.pptx

Question 6

Two-factor authentication (2FA) in the workplace adds security by:

Accepted Answer

Requiring a password plus a second verification method

Answer

Requiring two different passwords

Answer

Doubling the length of the password

Answer

Using two separate computers to log in