Office Technology and Software Applications Flashcards
7 cards from real COA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Office Technology and Software Applications flashcards as text
In Microsoft Excel, which function returns the number of cells that meet a single specified condition?
Answer: COUNTIF
COUNTIF counts cells within a range that meet a single condition you specify.
When setting up a mail merge in Microsoft Word, which file typically serves as the data source?
Answer: An Excel spreadsheet or CSV file
Mail merge data sources are commonly Excel spreadsheets or CSV files containing the recipient information.
Which cloud storage service is integrated directly into Microsoft 365 for file saving and sharing?
Answer: OneDrive
OneDrive is Microsoft's cloud storage platform built into Microsoft 365 applications.
In Microsoft Outlook, what feature allows you to send an email at a scheduled future time?
Answer: Delay Delivery
The Delay Delivery feature in Outlook lets you compose a message now and schedule it to be sent at a later date and time.
Which keyboard shortcut is used to insert a hyperlink in most Microsoft Office applications?
Answer: Ctrl+K
Ctrl+K opens the Insert Hyperlink dialog in Word, Excel, PowerPoint, and Outlook.
What does the term 'cloud computing' mean in an office context?
Answer: Storing and accessing data over the internet rather than on local hardware
Cloud computing refers to delivering computing services—storage, software, and processing—over the internet.
In a spreadsheet, an absolute cell reference is written as:
Answer: $A$1
The dollar sign ($) before the column letter and row number locks the reference so it doesn't change when copied.