Show By J. Carlton Collins, CPA Q. I receive a weekly sales report from our European affiliate that has between 1,260 and 2,100 city names spelled using a native spelling that does not match what we use here in our offices (42 city names "misspelled" 30 to 50 times each). To correct these spelling issues so the city names can be used to merge their data with our data, I perform 42 separate search-and-replace operations each week, which takes a lot of time. I'm working to have the spelling problems corrected at the affiliate offices in Europe, but in the meantime, is there an easier way to correct them than using Word's Search and Replace tool? A. If this problem is a simple matter of different spellings, then instead of performing 42 individual search-and-replace operations, you can press the F7 key to spellcheck your entire worksheet or workbook. In this case, if you use the Change button (as it sounds like you do), this spellcheck operation requires you to correct each spelling error one at a time — up to 2,100 times. Fortunately, there is a better way to use the spellcheck tool. Instead of pressing the Change button for each misspelled word in the document, you can correct all of your misspelled cities as larger blocks of corrections (one block of corrections for each city name) by rapidly clicking the Change All button 42 times, as pictured below. This approach results in a single spellcheck operation for the entire document, which is much faster than performing 42 individual search-and-replace operations.
About the author J. Carlton Collins, CPA, () is a technology consultant, a conference presenter, and a JofA contributing editor. Submit a question Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to . We regret being unable to individually answer all submitted questions. Excel 2000 – Study Questions for Exam 11. __________, a primary part of Excel, pictorially represent(s) data. a. Worksheets b. Charts c. Databases d. Web support 16. In the AutoFormat dialog box shown in the accompanying figure, the __________ can be used to obtain Help on any box or button located in the dialog box.
144. In the Print dialog box in the
accompanying figure, the __________ instructs Excel to print the selected range. Excel 2000 – Answers to Study Questions for Exam 1 1. b (07Excl-1-6) __________, a primary part of Excel, pictorially
represent(s) data. Return To ITE 140 Home Page When you run the spell checker in a workbook Excel automatically check the spelling in all worksheets at once?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.
Do you have selected a cell with a formula which of the following can you use to copy that 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.
When you set the page scaling to Backstage view you can fit all worksheet content on one page?To fit all worksheet content on one page, you can set page scaling in Backstage view. To print a worksheet contents across the length of a page, you can use portrait orientation. When you enter a value in a worksheet cell, it is automatically left-aligned.
Where can you see a preview of how your worksheet will look when printed including headers group of answer choices?When you select one or more sheets and then click File > Print, you'll see a preview of how the data will appear on the printout.
|