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

The SUM function automatically adds all values in a specified range, making it the foundational function for totaling expense columns in budget tracking spreadsheets.

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

Phishing emails should be reported to IT security without clicking any embedded links, which could trigger malware installation or credential theft, and then deleted from the inbox.

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

In standard business letter format, the subject line (preceded by 'Re:' or 'Subject:') appears after the salutation and immediately before the body, alerting the reader to the letter's topic.

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

Two-factor authentication requires users to verify their identity through a second method (such as a code sent to a phone) in addition to a password, providing a critical additional security layer.

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

A flat (horizontal) organizational structure has few management layers between leadership and front-line employees, encouraging faster decision-making, greater employee autonomy, and more direct communication.

CAP - Certified Administrative Professional Practice Test

CAP - Certified Administrative Professional Practice Test

CAP Certified Administrative Professional MCQ 2