Page 244 - Excel 2013 All-in-One For Dummies

226 Marking Invalid Data
✦ Translate opens the Research pane with the Translation option selected. Here you can look up a translation for a particular term that you enter into the Search For text box or for the contents of the current cell automatically entered into this text box in the language listed in the To drop-down list box.
When the Research Task pane is open, you can change the online resource to use when looking up the term in the Search For text box by selecting it from the Show Results From drop-down list box immediately beneath. These online resources include such sites as the Encarta Dictionary, Thesaurus (available for a variety of European languages), Translation (for translat-
ing to and from English and a variety of languages), the Bing search engine, Factiva iWorks, and HighBeam Research.
After you click the Start Searching button (the arrow pointing to the right in the green square to the immediate right of the Search For text box) or you select a new online resource, Excel searches for your search text online in the selected resources, and the program displays these results in the lower part of the Research Task pane (beneath the Show Results From drop-down list box and the Back button). Depending on the resource used, these results may appear in the form of links to specific web pages that you can pursue by clicking them or in the form of listed information that you can read in the Research Task pane.
When you click a web link in the research results, Excel opens your web browser (usually Microsoft Internet Explorer 10, which ships with Microsoft Office 2013), and it displays the targeted linked page. After you finish reading its information and/or following the links on its page, you can return to Excel by clicking the Close button in the upper-right corner of the web browser window.
To change which online resources appear on the Show Results From drop- down menu, click the Research Options link that appears at the very bottom of the Research Task pane. When you click this link, Excel opens a Research Options dialog box that enables you to add or remove particular reference books and sites by either removing or adding check marks to their check box items. To widen or narrow the Research Task pane, position the mouse pointer on the border between the right edge of the Excel program window and the Task pane and then when the pointer becomes a two-headed arrow, drag to the left (to widen) or right (to narrow).
Marking Invalid Data
In addition to using the Data Validation feature to restrict what kind of data can be entered into cell ranges of a worksheet, you can use it to mark all