COA Office Technology and Software Applications 2

Question 1

In Microsoft Excel, which function returns the number of cells that meet a single specified condition?

Accepted Answer

COUNTIF

Answer

COUNTIF counts cells within a range that meet a single condition you specify.

Question 2

When setting up a mail merge in Microsoft Word, which file typically serves as the data source?

Accepted Answer

An Excel spreadsheet or CSV file

Answer

Mail merge data sources are commonly Excel spreadsheets or CSV files containing the recipient information.

Question 3

Which cloud storage service is integrated directly into Microsoft 365 for file saving and sharing?

Accepted Answer

OneDrive

Answer

OneDrive is Microsoft's cloud storage platform built into Microsoft 365 applications.

Question 4

In Microsoft Outlook, what feature allows you to send an email at a scheduled future time?

Accepted Answer

Delay Delivery

Answer

The Delay Delivery feature in Outlook lets you compose a message now and schedule it to be sent at a later date and time.

Question 5

Which keyboard shortcut is used to insert a hyperlink in most Microsoft Office applications?

Accepted Answer

Ctrl+K

Answer

Ctrl+K opens the Insert Hyperlink dialog in Word, Excel, PowerPoint, and Outlook.

(COA) Certified Office Administration Practice Test