CAP Technology and Digital Tools

Question 1

Which Microsoft Office feature allows an administrative professional to automate repetitive tasks using recorded sequences of commands?

Accepted Answer

Macros

Answer

Pivot Tables

Answer

Conditional Formatting

Answer

Data Validation

Question 2

When managing a shared organizational calendar in Outlook, which permission level allows a colleague to view, create, and modify appointments?

Accepted Answer

Editor

Answer

Reviewer

Answer

Author

Answer

Contributor

Question 3

An administrative professional needs to combine data from multiple Excel worksheets into a single summary sheet. Which feature is most efficient for this?

Accepted Answer

Consolidate

Answer

VLOOKUP

Answer

Sparklines

Answer

Solver

Question 4

Which cloud collaboration tool is best suited for co-authoring documents in real time with remote colleagues?

Accepted Answer

SharePoint Online / Microsoft 365

Answer

Windows File Explorer

Answer

Adobe Acrobat Reader

Answer

WinZip

Question 5

A CAP professional must protect a Word document so only authorized users can edit certain sections. Which feature accomplishes this?

Accepted Answer

Restrict Editing

Answer

Track Changes

Answer

Document Encryption

Answer

Digital Signature

Question 6

Which database concept describes a field whose value uniquely identifies each record in a table?

Accepted Answer

Primary Key

Answer

Foreign Key

Answer

Index

Answer

Relationship