Which function capitalizes the first letter of every word in a range?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Digital Information Technology Exam. Utilize engaging flashcards and diverse multiple-choice questions. Each question offers hints and explanations to enhance your understanding. Get exam-ready now!

Multiple Choice

Which function capitalizes the first letter of every word in a range?

Explanation:
This question tests proper capitalization of text in a range. The function that capitalizes the first letter of every word is PROPER. It converts each word so its initial character becomes uppercase while the remaining letters in that word are turned to lowercase, so a string like "john doe" becomes "John Doe." The other options don’t fit because UPPER makes every character uppercase, LOWER makes everything lowercase, and CAP isn’t a standard function for this task in common spreadsheet tools. Using PROPER gives you consistent title case across the entire range.

This question tests proper capitalization of text in a range. The function that capitalizes the first letter of every word is PROPER. It converts each word so its initial character becomes uppercase while the remaining letters in that word are turned to lowercase, so a string like "john doe" becomes "John Doe." The other options don’t fit because UPPER makes every character uppercase, LOWER makes everything lowercase, and CAP isn’t a standard function for this task in common spreadsheet tools. Using PROPER gives you consistent title case across the entire range.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy