CPS Technology & Data Management 2

Question 1

An administrative professional needs to combine a customer list in Excel with a form letter in Word to produce 300 personalized letters. Which feature should be used?

Accepted Answer

Mail Merge

Answer

Mail Merge pulls records from a data source into a template to create personalized documents in bulk.

Question 2

Which Excel function returns a value from a table by matching a lookup value in the first column?

Accepted Answer

VLOOKUP

Answer

VLOOKUP searches the first column of a range and returns a value from a specified column in the same row.

Question 3

In a relational database, what is the purpose of a primary key?

Accepted Answer

To uniquely identify each record in a table

Answer

A primary key holds a unique value for every record so that no two rows are identical.

Question 4

A coworker receives an email that appears to come from IT asking them to confirm their password through a link. What is this most likely?

Accepted Answer

A phishing attempt

Answer

Phishing uses fake but legitimate-looking messages to trick users into revealing credentials.

Question 5

Which backup strategy copies only the files that changed since the last full backup, regardless of any backups in between?

Accepted Answer

Differential backup

Answer

A differential backup captures all changes since the last full backup, so restoring needs only the full backup plus the latest differential.

CPS - Certified Professional Secretary Practice Test

CPS - Certified Professional Secretary Practice Test

CPS Technology & Data Management 2