DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Corrects two initial uppercase letters by changing the second letter to lowercase.
|
|
|
Changes addition and subtraction signs that may not make sense in a created formula.
|
|
|
Capitalizes the first letter in the names of days.
|
|
|
Replaces commonly misspelled words with their correct spelling.
|
Detailed explanation-1: -A quick way to correct a misspelled word in Microsoft Word is to right-click on the word that has a red wavy underline. The resulting pop-up menu contains spelling suggestions which you can then select and have the misspelled word replaced.
Detailed explanation-2: -Auto-Correction uses your keyboard dictionary to spellcheck words as you type, automatically correcting misspelled words for you. To use it, just type in a text field. To make sure that Auto-Correction is turned on: Open the Settings app.
Detailed explanation-3: -You can use the AutoCorrect feature to correct typos, capitalization errors, and misspelled words, as well as automatically insert symbols and other pieces of text.
Detailed explanation-4: -Auto-correct is a feature available on Android and Apple smartphones, PCs and applications like Outlook. Its goal is to make typing a little easier by automatically changing words, letters or punctuation it thinks you entered incorrectly.