Answer Happy

Answer 35 to 49
D BLOCKED We ran into a problem with this file and call save any new changes. Pleas avoid losing your woTK d. All of the Above 32. When you import data from a text file using a delimiter, each data field is imported into a separate column a. True b. False 33. Flash Fill detects patterns in your data and autofill the remaining cells for you a. True b. False 34. Flash Fill can be used to combine data from contiguous cells into a single cell or to split data from a single cell into multiple cells a. True b. False 35. Using Flash Fill fills the cells with static content instead of formulas, making it easier to move and manipulate the data a. True b. False 36. Excel's Text to Columns feature allows you to split data into separate columns if there is a consistent character at which Excel can split the data (the delimiter) or the data can be split at a specific number of characters a. True b. False 37. Data validation rules help to prevent errors in your workbooks a. True b. False 38. Data validation rules prevent users from entering invalid data or data that may cause errors in formulas a. True b. False 39. Data validation rules can limit cell entries to a specific data type or list of acceptable values a. False b. False 40. Through the Consolidate dialog, you can summarize data from multiple worksheets for a range of cells at once a. True save a copy b. False 41. A comment is a note you add to a cell in a worksheet a. False b. True 42. A hyperlink is text or a graphic that can be clicked to open another location in the same file, another file, or a Web page a. True b. False 43. If you intend to share the workbook, you should set worksheet and workbook protection first a. True b. False 44. When you enable worksheet protection, users will not be able to edit or delete any data in the worksheet unless you explicitly unlock specific cells a. True b. False 45. You cannot apply protection after the workbook has been shared a. True b. False 46. The Compatibility Checker lists the items in your workbook that may be lost or downgraded if you save the workbook in an earlier Microsoft Excel format a. True b. False 47. When your worksheet is protected, you can add a password to your worksheet to require users to enter the password before they can unprotect the worksheet and make changes a. True b. False 48. In Excel, you can create a master worksheet to summarize data a. True b. False 49. When cells have a data validation rule applied, you can add a prompt that will appear every time a user clicks one of the cells requiring data validation a. True