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

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?

Accepted Answer

Editor

Answer

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?

Accepted Answer

Consolidate

Answer

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?

Accepted Answer

SharePoint Online / Microsoft 365

Answer

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?

Accepted Answer

Restrict Editing

Answer

Word's Restrict Editing feature lets you limit formatting changes and designate editable sections for specific users.

CAP - Certified Administrative Professional Practice Test

CAP - Certified Administrative Professional Practice Test

CAP Technology and Digital Tools