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

Which Microsoft Word feature automatically corrects common typing errors as you type?
Answer: AutoCorrect
AutoCorrect automatically fixes common spelling mistakes, capitalization errors, and typos in real time.
What is the primary purpose of a pivot table in Excel?
Answer: To summarize and analyze large datasets interactively
Pivot tables allow users to quickly summarize, group, and analyze large amounts of data without formulas.
In Microsoft PowerPoint, the 'Slide Master' is used to:
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.
Which file format is best for sharing documents that must maintain their formatting across different devices?
Answer: .pdf
PDF (Portable Document Format) preserves layout, fonts, and graphics regardless of the device or operating system used to view it.
What does VoIP stand for in office communications?
Answer: Voice over Internet Protocol
VoIP (Voice over Internet Protocol) transmits voice calls over the internet instead of traditional phone lines.
In Microsoft Excel, the VLOOKUP function searches for a value in the:
Answer: First column of a table
VLOOKUP (Vertical Lookup) always searches for the lookup value in the first (leftmost) column of the specified range.
Which Microsoft 365 app is specifically designed for team chat, file sharing, and video meetings?
Answer: Microsoft Teams
Microsoft Teams is the hub for teamwork in Microsoft 365, combining chat, meetings, calls, and collaboration.