CAP Technology and Digital Tools 1 — Questions and Answers
Question 1: Which Microsoft Office feature allows an administrative professional to automate repetitive tasks using recorded sequences of commands?
- Macros (Correct answer)
- Pivot Tables
- Conditional Formatting
- Data Validation
Correct answer: Macros
Macros in Microsoft Office record and replay sequences of commands to automate repetitive tasks.
Question 2: When managing a shared organizational calendar in Outlook, which permission level allows a colleague to view, create, and modify appointments?
- Reviewer
- Author
- Editor (Correct answer)
- Contributor
Correct answer: Editor
The Editor permission level in Outlook grants rights to view, create, and modify calendar items.
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?
- VLOOKUP
- Consolidate (Correct answer)
- Sparklines
- Solver
Correct answer: Consolidate
Excel's Consolidate feature aggregates data from multiple worksheets or workbooks into a single summary.
Question 4: Which cloud collaboration tool is best suited for co-authoring documents in real time with remote colleagues?
- SharePoint Online / Microsoft 365 (Correct answer)
- Windows File Explorer
- Adobe Acrobat Reader
- WinZip
Correct answer: SharePoint Online / Microsoft 365
SharePoint Online and Microsoft 365 enable simultaneous real-time co-authoring of documents across locations.
Question 5: A CAP professional must protect a Word document so only authorized users can edit certain sections. Which feature accomplishes this?
- Track Changes
- Document Encryption
- Restrict Editing (Correct answer)
- Digital Signature
Correct answer: Restrict Editing
Word's Restrict Editing feature lets you limit formatting changes and designate editable sections for specific users.
Question 6: Which database concept describes a field whose value uniquely identifies each record in a table?
- Foreign Key
- Index
- Primary Key (Correct answer)
- Relationship
Correct answer: Primary Key
A primary key is a field or combination of fields whose value uniquely identifies each record in a database table.
CAP Technology and Digital Tools 1
Which Microsoft Office feature allows an administrative professional to automate repetitive tasks using recorded sequences of commands?