To accept a suggested spelling for that instance only, which of the following would you click?

/en/word2016/charts/content/

Introduction

Worried about making mistakes when you type? Don't be. Word provides you with several proofing features—including the Spelling and Grammar tool—that can help you produce professional, error-free documents.

Optional: Download our practice document.

Watch the video below to learn more about using the Spelling and Grammar tool.

  1. From the Review tab, click the Spelling & Grammar command.

    To accept a suggested spelling for that instance only, which of the following would you click?

  2. The Spelling and Grammar pane will appear on the right. For each error in your document, Word will try to offer one or more suggestions. You can select a suggestion and click Change to correct the error.

  3. Word will move through each error until you have reviewed all of them. After the last error has been reviewed, a dialog box will appear confirming that the spelling and grammar check is complete. Click OK.

If no suggestions are given, you can manually type the correct spelling in your document.

Ignoring "errors"

The spelling and grammar check is not always correct. Particularly with grammar, there are many errors Word will not notice. There are also times when the spelling and grammar check will say something is an error when it's actually not. This often happens with names and other proper nouns, which may not be in the dictionary.

If Word says something is an error, you can choose not to change it. Depending on whether it's a spelling or grammatical error, you can choose from several options.

For spelling "errors":

  • Ignore: This will skip the word without changing it.
  • Ignore All: This will skip the word without changing it, and it will also skip all other instances of the word in the document.
  • Add: This adds the word to the dictionary so it will never come up as an error. Make sure the word is spelled correctly before choosing this option.

For grammar "errors":

  • Ignore: This will skip the word or phrase without changing it.

For some grammatical errors, Word will provide an explanation for why it thinks something is incorrect. This can help you determine whether you want to change or ignore it.

Automatic spelling and grammar checking

By default, Word automatically checks your document for spelling and grammar errors, so you may not even need to run a separate check. These errors are indicated by colored wavy lines.

  • The red line indicates a misspelled word.
  • The blue line indicates a grammatical error, including misused words.

A misused word—also known as a contextual spelling error—occurs when a word is spelled correctly but used incorrectly. For example, if you used the phrase Deer Mr. Theodore at the beginning of a letter, deer would be a contextual spelling error. Deer is spelled correctly, but it is used incorrectly in the letter. The correct word is Dear.

To correct spelling errors:

  1. Right-click the underlined word, then select the correct spelling from the list of suggestions.

  2. The corrected word will appear in the document.

You can also choose to Ignore All instances of an underlined word or add it to the dictionary.

To correct grammar errors:

  1. Right-click the underlined word or phrase, then select the correct spelling or phrase from the list of suggestions.

  2. The corrected phrase will appear in the document.

To change the automatic spelling and grammar check settings:

  1. Click the File tab to access Backstage view, then click Options.

  2. A dialog box will appear. On the left side of the dialog box, select Proofing. From here, you have several options to choose from. For example, if you don't want Word to mark spelling errors, grammar errors, or frequently confused words automatically, simply uncheck the desired option.

If you've turned off the automatic spelling and/or grammar checks, you can still go to the Review tab and click the Spelling & Grammar command to run a new check.

To hide spelling and grammar errors in a document:

If you're sharing a document like a resume with someone, you might not want that person to see the red and blue lines. Turning off the automatic spelling and grammar checks only applies to your computer, so the lines may still show up when someone else views your document. Fortunately, Word allows you to hide spelling and grammar errors so the lines will not show up on any computer.

  1. Click the File tab to go to Backstage view, then click Options.
  2. A dialog box will appear. Select Proofing, then check the box next to Hide spelling errors in this document only and Hide grammar errors in this document only,then click OK.

  3. The lines in the document will be hidden.

Challenge!

  1. Open our practice document. If you already downloaded our practice document in order to follow along with the lesson, be sure to download a fresh copy by clicking the link in this step.
  2. Run a Spelling & Grammar check.
  3. Ignore the spelling of names like Marcom.
  4. Correct all other spelling and grammar mistakes.
  5. When you're finished, your document should look like this:

/en/word2016/track-changes-and-comments/content/

/en/excel2016/using-find-replace/content/

Introduction

Before sharing a workbook, you'll want to make sure it doesn't include any spelling errors. Fortunately, Excel includes a Spell Check tool you can use to make sure everything in your workbook is spelled correctly.

If you've used the Spell Check feature in Microsoft Word, just be aware that the Spell Check tool in Excel, while helpful, is not as powerful. For example, it won't check for grammar issues or check spelling as you type.

Optional: Download our practice workbook.

To use Spell Check:

  1. From the Review tab, click the Spelling command.

  2. The Spelling dialog box will appear. For each spelling error in your worksheet, Spell Check will try to offer suggestions for the correct spelling. Choose a suggestion, then click Change to correct the error.

  3. A dialog box will appear after reviewing all spelling errors. Click OK to close Spell Check.

If there are no appropriate suggestions, you can also enter the correct spelling manually.

Ignoring spelling "errors"

Spell Check isn't always correct. It will sometimes mark certain words as incorrect even if they're spelled correctly. This often happens with names, which may not be in the dictionary. You can choose not to change a spelling "error" using one of the following three options:

  • Ignore Once: This will skip the word without changing it.
  • Ignore All: This will skip the word without changing it and also skip all other instances of the word in your worksheet.
  • Add: This adds the word to the dictionary so it will never appear as an error again. Make sure the word is spelled correctly before choosing this option.

Challenge!

  1. Open our practice workbook.
  2. Click the Challenge worksheet tab in the bottom-left of the workbook.
  3. Run the Spell Check to correct any spelling errors in the workbook.
  4. Correct the words coffe and medum using the suggested spelling.
  5. Ignore the spelling suggestion for the word Amanecer.
  6. When you're finished, your worksheet should look like this:

  7. Bonus Step! There is one error Spell Check didn't catch. Can you spot it? Hint: It's in one of the item descriptions.

/en/excel2016/page-layout-and-printing/content/

When you use the spell checker in a workbook Excel will check the spelling of cell contents in all of the worksheets at once true false?

To check spelling for any text on your worksheet, click Review > Proofing > Spelling. Here are some things that happen when you use the spelling checker: If you select a single cell for spell check, Excel checks the entire worksheet, including the comments, page headers, footers and graphics.

When you use the spell checker in a workbook Excel will check the spelling of cell contents in all of the worksheets at once quizlet?

When you run the spell checker in a workbook, Excel automatically checks the spelling in all worksheets at once. You can use the DELETE key to cleat cell contents. When you enter a value in a worksheet cell, it automatically left-aligned. You can edit the cell contents in the Formula bar or in the cell itself.

What feature inserts a function that totals the cell above or to the left of the selected cell?

Sum a range of cells -- SUM Function The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?

Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.