COA Office Technology and Software Applications 3

Question 1

Which Microsoft Word feature automatically corrects common typing errors as you type?

Accepted Answer

AutoCorrect

Answer

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?

Accepted Answer

To summarize and analyze large datasets interactively

Answer

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:

Accepted Answer

Set consistent design, fonts, and layouts across all slides

Answer

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?

Accepted Answer

.pdf

Answer

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?

Accepted Answer

Voice over Internet Protocol

Answer

VoIP (Voice over Internet Protocol) transmits voice calls over the internet instead of traditional phone lines.

(COA) Certified Office Administration Practice Test