CAP Certified Administrative Professional MCQ 2 — Questions and Answers
Question 1: An administrative professional is asked to create a budget tracking spreadsheet. Which spreadsheet function is most useful for automatically summing expense columns?
- VLOOKUP
- SUM (Correct answer)
- CONCATENATE
- INDEX
Correct answer: SUM
The SUM function automatically adds all values in a specified range, making it the foundational function for totaling expense columns in budget tracking spreadsheets.
Budget management is a key competency in the CAP Technology Applications and Financial Management domains. The SUM function (=SUM(A1:A10)) adds all numerical values in a specified range, enabling automatic column totals that update dynamically as values are entered or changed. For budget tracking, administrative professionals typically use SUM to total expense categories, calculate running balances, and compare actuals to budgeted amounts.
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?
- Click the link in the email to verify whether it is legitimate
- Report it to the IT security team immediately without clicking any links, and delete it (Correct answer)
- Forward it to all colleagues to warn them by sharing the suspicious link
- Reply to the sender asking them to confirm their identity
Correct answer: Report it to the IT security team immediately without clicking any links, and delete it
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.
Cybersecurity awareness is increasingly integrated into the CAP Technology Applications domain. Phishing emails are fraudulent communications designed to steal credentials, install malware, or compromise organizational systems. The correct response is: do not click any links, do not download attachments, do not reply, immediately report the email to the IT security team, and delete the email. Forwarding the phishing email — even to warn colleagues — risks spreading the malicious link further.
Question 3: In a professional business letter, where does the subject line typically appear?
- Before the date
- After the salutation and before the body of the letter (Correct answer)
- At the very end after the signature block
- Immediately after the return address
Correct answer: After the salutation and before the body of the letter
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.
Standard business letter format places the subject line after the salutation and before the body text. The subject line, introduced with 'Re:' or 'Subject:', provides the reader with immediate context for the letter's purpose. This placement — after the greeting but before the main content — is a convention understood across professional settings. The CAP Business Communication domain includes correct letter formatting as a foundational competency.
Question 4: What is the purpose of 'two-factor authentication' (2FA) in workplace technology systems?
- It allows two people to share one account simultaneously
- It adds a second verification step beyond a password, significantly reducing unauthorized account access even if the password is compromised (Correct answer)
- It doubles the length of passwords required
- It allows systems to operate offline without network connectivity
Correct answer: It adds a second verification step beyond a password, significantly reducing unauthorized account access even if the password is compromised
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.
Two-factor authentication (2FA) is a security protocol that requires two independent forms of identity verification before granting access to an account or system. The first factor is typically something the user knows (password), and the second is something they have (a one-time code sent to a registered phone or email, or generated by an authenticator app) or something they are (biometric like a fingerprint). The CAP Technology Applications domain covers 2FA as a standard security practice.
Question 5: Which type of organizational chart structure shows a flat hierarchy with minimal layers between leadership and front-line staff?
- Tall hierarchical structure
- Flat or horizontal structure (Correct answer)
- Matrix structure only
- Functional divisional structure
Correct answer: Flat or horizontal structure
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.
Organizational structure knowledge is assessed in the CAP exam because administrative professionals must navigate, document, and communicate within their organization's structure. A flat structure minimizes hierarchy levels, typically giving each manager a wide span of control. Benefits include faster communication flow, greater employee empowerment, and reduced bureaucracy. Administrative professionals who understand their organization's structure can more effectively route communications and identify decision-makers.
Question 6: When proofreading a formal document, what is the most effective strategy for catching typographical errors?
- Read the document once at normal reading speed and rely on spell-check alone
- Read the document slowly from the end backward, word by word, to prevent the brain from auto-correcting errors (Correct answer)
- Read only the first and last paragraphs to check for consistency
- Ask a colleague to check only for spelling, not grammar
Correct answer: Read the document slowly from the end backward, word by word, to prevent the brain from auto-correcting errors
Reading backward word-by-word forces the brain to focus on individual words rather than anticipated meaning, significantly improving the detection of typographical errors that the brain would otherwise skip.
The CAP Business Communication and Writing domain covers professional proofreading techniques as a critical competency. When reading forward, the brain tends to auto-correct errors based on context and expectation, causing many typos to go unnoticed. Reading backward — from the last word to the first — breaks this predictive reading pattern and forces attention on each word in isolation. Combined with multiple passes, this technique significantly reduces errors in formal documents.
CAP Certified Administrative Professional MCQ 2
An administrative professional is asked to create a budget tracking spreadsheet.
Which spreadsheet function is most useful for automatically summing expense columns?