BIS 155 Week 4 Office Integration and Mail Merge - Quiz

1. (TCO 8) Which of the following is one of the most common file types imported into Excel? (Points : 2)
2. (TCO 8) Which of the following is NOT a text file? (Points : 2)
3. (TCO 8) Which of the following is NOT a method for refreshing data? (Points : 2)
4. (TCO 8) The Convert Text to Columns Wizard allows you to choose the file type, such as Delimited or ________ width. (Points : 2)
5. (TCO 8) Which of the following is a frequently used function to manipulate txt? (Points : 2)
6. (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. (Points : 2)
7. (TCO 8) Which of the following cannot be used in a CONCATENATE function? (Points : 2)
8. (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. (Points : 2)
9. (TCO 8) The New Comment command is located on the ________ tab. (Points : 2)
10. (TCO 8) An alternative method for inserting a comment in a cell includes: (Points : 2)
11. (TCO 8) The command to track changes is located on the ________ tab. (Points : 2)
12. (TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab. (Points : 2)
13. (TCO 8) Windows can search for files by author name or keywords that have been entered into ________. (Points : 2)
14. (TCO 8) Which function is similar to the Find and Replace feature? (Points : 2) 
15. (TCO 8) To encrypt a workbook with a password, click Info on the File tab, click ________, and then select Encrypt with Password. (Points : 2)
Powered by