CAP Certified Administrative Professional MCQ 2

Question 1

An administrative professional is asked to create a budget tracking spreadsheet. Which spreadsheet function is most useful for automatically summing expense columns?

Accepted Answer

SUM

Answer

VLOOKUP

Answer

CONCATENATE

Answer

INDEX

Question 2

Which of the following is the correct action when receiving an email that appears to be a phishing attempt on a work account?

Accepted Answer

Report it to the IT security team immediately without clicking any links, and delete it

Answer

Click the link in the email to verify whether it is legitimate

Answer

Forward it to all colleagues to warn them by sharing the suspicious link

Answer

Reply to the sender asking them to confirm their identity

Question 3

In a professional business letter, where does the subject line typically appear?

Accepted Answer

After the salutation and before the body of the letter

Answer

Before the date

Answer

At the very end after the signature block

Answer

Immediately after the return address

Question 4

What is the purpose of 'two-factor authentication' (2FA) in workplace technology systems?

Accepted Answer

It adds a second verification step beyond a password, significantly reducing unauthorized account access even if the password is compromised

Answer

It allows two people to share one account simultaneously

Answer

It doubles the length of passwords required

Answer

It allows systems to operate offline without network connectivity

Question 5

Which type of organizational chart structure shows a flat hierarchy with minimal layers between leadership and front-line staff?

Accepted Answer

Flat or horizontal structure

Answer

Tall hierarchical structure

Answer

Matrix structure only

Answer

Functional divisional structure

Question 6

When proofreading a formal document, what is the most effective strategy for catching typographical errors?

Accepted Answer

Read the document slowly from the end backward, word by word, to prevent the brain from auto-correcting errors

Answer

Read the document once at normal reading speed and rely on spell-check alone

Answer

Read only the first and last paragraphs to check for consistency

Answer

Ask a colleague to check only for spelling, not grammar