(TCO 8) Which of the following is one of the most common file types imported into Excel?
Question 2. Question :
(TCO 8) Which of the following is NOT a text file?
Question 3. Question :
(TCO 8) Which of the following is NOT a method for refreshing data?
Click the Refresh All command.
Save the Excel workbook.
Click the Refresh All arrow, then click Refresh.
Right-click in a range of data and then select Refresh.
Question 4. Question :
(TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width.
Question 5. Question :
(TCO 8) Which of the following is a frequently used function to manipulate txt?
Question 6. Question :
(TCO 8) To change the text string JANE doe to jane doe, use the ________ function.
Question 7. Question :
(TCO 8) Which of the following will produce the same result as the CONCATENATE function?
Question 8. Question :
(TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge.
Type New List
Use Existing List
Import from Excel
Select from Outlook Contacts
Question 9. Question :
(TCO 8) The New Comment command is located on the ________ tab.
Question 10. Question :
(TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________.
Split Names Wizard
Convert Text to Columns Wizard
Question 11. Question :
(TCO 8) The command to track changes is located on the ________ tab.
Question 12. Question :
(TCO 8) If you have ________ configured as your e-mail client, you can e-mail an Excel file directly from Excel.
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
Question 14. Question :
(TCO 8) All EXCEPT ___________ are Excel functions that help you manipulate text.
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