EAC EAC Technology & Digital Tools 2

Question 1

When an executive assistant creates a database to track client contacts, which Microsoft Office tool is most appropriate?

Accepted Answer

Microsoft Access or Excel

Answer

Microsoft Access is designed for database management, while Excel can handle simpler contact tracking with sorting and filtering capabilities.

Question 2

What is the best practice when managing an executive's email inbox to ensure nothing critical is missed?

Accepted Answer

Use folders, flags, and filters to categorize and prioritize emails by urgency and topic

Answer

Using folders, flags, and filters allows systematic organization of emails so urgent or important items are surfaced and nothing critical is overlooked.

Question 3

Which tool would an executive assistant most likely use to create a professional organizational chart for a new department?

Accepted Answer

Microsoft Visio or PowerPoint SmartArt

Answer

Microsoft Visio is purpose-built for diagrams and charts, while PowerPoint's SmartArt provides accessible org chart templates for professional presentations.

Question 4

An executive assistant is asked to automate repetitive data entry tasks in Excel. Which feature should they use?

Accepted Answer

Macros or Power Automate

Answer

Macros record and replay repetitive actions in Excel, while Power Automate can handle broader workflow automation, both reducing manual data entry time.

Question 5

What is the recommended approach when an executive assistant receives a suspicious phishing email appearing to be from the CEO?

Accepted Answer

Report it to IT security immediately without clicking links or attachments

Answer

Reporting phishing emails to IT security immediately, without engaging with links or attachments, is the safest and most responsible response.

(EAC) Executive Assistant Certification Practice Test

(EAC) Executive Assistant Certification Practice Test

EAC EAC Technology & Digital Tools 2