COA Office Technology and Software Applications 2 — Questions and Answers
Question 1: In Microsoft Excel, which function returns the number of cells that meet a single specified condition?
- SUMIF
- COUNTIF (Correct answer)
- AVERAGEIF
- COUNTA
Correct answer: COUNTIF
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?
- A PowerPoint presentation
- An Excel spreadsheet or CSV file (Correct answer)
- A PDF document
- A OneNote notebook
Correct answer: An Excel spreadsheet or CSV file
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?
- Google Drive
- Dropbox
- OneDrive (Correct answer)
- iCloud
Correct answer: OneDrive
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?
- Quick Steps
- Delay Delivery (Correct answer)
- Rules Wizard
- Out of Office Reply
Correct 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.
Question 5: Which keyboard shortcut is used to insert a hyperlink in most Microsoft Office applications?
- Ctrl+H
- Ctrl+K (Correct answer)
- Ctrl+L
- Ctrl+U
Correct answer: Ctrl+K
Ctrl+K opens the Insert Hyperlink dialog in Word, Excel, PowerPoint, and Outlook.
Question 6: What does the term 'cloud computing' mean in an office context?
- Using high-powered desktop computers
- Storing and accessing data over the internet rather than on local hardware (Correct answer)
- Printing documents wirelessly
- Using encrypted USB drives for storage
Correct 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.
Question 7: In a spreadsheet, an absolute cell reference is written as:
- A1
- $A$1 (Correct answer)
- A$1$
- [A1]
Correct answer: $A$1
The dollar sign ($) before the column letter and row number locks the reference so it doesn't change when copied.
COA Office Technology and Software Applications 2
In Microsoft Excel, which function returns the number of cells that meet a single specified condition?