Question 1. � Question : � (TCO 8) Which of the following is one of the most common file types imported into Excel? Text PowerPoint Web Word Question 2. � Question : � (TCO 8) To create a connection between the original data source and the imported data in Excel, use the _____ on the Data tab. Data Validation command Connection command Edit Links command Commands in the Get External Data group Question 3. � Question : � (TCO 8) All of the following will display data range properties EXCEPT click Properties in the Connections Group. click Edit Links. click Refresh All arrow and select Connection Properties. click Connections then click Properties. Question 4. � Question : � (TCO 8) Text to Columns command splits text in one column into separate _____. columns rows worksheets workbooks Question 5. � Question : � (TCO 8) Which of the following is an example of a text string? =B5*B7 =SUM(A5:A10) =IF(B3>B4, B3) John Doe Question 6. � Question : � (TCO 8) To change the text string JANE doe to jane doe, use the _____ function. CONCATENATE PROPER UPPER LOWER Question 7. � Question : � (TCO 8) Which of the following cannot be used in a CONCATENATE function? Text Numbers Multiple-cell references Single-cell references Question 8. � Question : � (TCO 8) In Microsoft Word, the commands used to perform a mail merge are found on the _____ tab of the Ribbon. Merge Mailings Home Review Question 9. � Question : � (TCO 8) In Excel, the Compare and Merge command is located on which of the following tabs? Review tab Data tab File tab None of the above Question 10. Question : � (TCO 8) An alternative method for inserting a comment in a cell includes typing the comment into the cell and then clicking New Comment. right-click the cell and choose Insert Comment. left-click the cell and choose Insert Comment. clicking paste on the Home tab after typing in the comment. Question 11. Question : � (TCO 8) The _____ tab on the Page Setup dialog box provides options for printing comments. Page Margins Header/Footer Sheet Question 12. Question : � (TCO 8) The command to send an Excel workbook by e-mail is located on the _____ tab. File, Share Home, Send File, Options View, Email Question 13. Question : � (TCO 8) Windows can search for files by author name or keywords that have been entered into _____. a file name the Trust Center document properties cell A1 Question 14. Question : � (TCO 8) All EXCEPT _____ are Excel functions that help you manipulate text. PROPER UPPER SUBSTITUTE RESPOND Question 15. Question : � (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password. Check for Issues Protect Workbook Manage Versions Options
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer