COA Office Technology and Software Applications 3 — Questions and Answers
Question 1: Which Microsoft Word feature automatically corrects common typing errors as you type?
- Spell Check
- AutoCorrect (Correct answer)
- Grammar Check
- Find & Replace
Correct answer: AutoCorrect
AutoCorrect automatically fixes common spelling mistakes, capitalization errors, and typos in real time.
Question 2: What is the primary purpose of a pivot table in Excel?
- To create charts from data
- To summarize and analyze large datasets interactively (Correct answer)
- To sort alphabetically
- To merge cells together
Correct answer: To summarize and analyze large datasets interactively
Pivot tables allow users to quickly summarize, group, and analyze large amounts of data without formulas.
Question 3: In Microsoft PowerPoint, the 'Slide Master' is used to:
- Lock slides from editing
- Set consistent design, fonts, and layouts across all slides (Correct answer)
- Add animations to every slide
- Convert slides to PDF format
Correct answer: Set consistent design, fonts, and layouts across all slides
The Slide Master controls the overall design template so formatting changes apply consistently to all slides.
Question 4: Which file format is best for sharing documents that must maintain their formatting across different devices?
- .docx
- .txt
- .pdf (Correct answer)
- .rtf
Correct answer: .pdf
PDF (Portable Document Format) preserves layout, fonts, and graphics regardless of the device or operating system used to view it.
Question 5: What does VoIP stand for in office communications?
- Virtual Office Internet Protocol
- Voice over Internet Protocol (Correct answer)
- Video Operational Interface Platform
- Verified Outbound IP
Correct answer: Voice over Internet Protocol
VoIP (Voice over Internet Protocol) transmits voice calls over the internet instead of traditional phone lines.
Question 6: In Microsoft Excel, the VLOOKUP function searches for a value in the:
- Bottom row of a table
- First column of a table (Correct answer)
- Last column of a table
- Middle column of a table
Correct answer: First column of a table
VLOOKUP (Vertical Lookup) always searches for the lookup value in the first (leftmost) column of the specified range.
Question 7: Which Microsoft 365 app is specifically designed for team chat, file sharing, and video meetings?
- Microsoft Planner
- Microsoft Teams (Correct answer)
- Microsoft Stream
- Microsoft Yammer
Correct answer: Microsoft Teams
Microsoft Teams is the hub for teamwork in Microsoft 365, combining chat, meetings, calls, and collaboration.
COA Office Technology and Software Applications 3
Which Microsoft Word feature automatically corrects common typing errors as you type?